Total costs from a series of lists

AppSheet AppSheet Q&A
1

I need to be able to have several lists list that allow individual items to be checked. These items will have associated costs. After the needed ones are checked, a total field will be activated and the total cost will be provided. Guidance? Thanks!

1 Like
2

@Hank_Austin
You can try with this:

SUM(
	SELECT(
		Tablename[PriceColumn],
		IN(
			[CostItemsColumnName],
			[_THISROW].[EnumlistColumnName]
		)
	)
)
2 Likes
3

Thank you I will!