How to write a formula Using Select or Sumifs in appsheet

hi i have created a table where i have columns named Start date and End date, and total column…

when a user selects start and end date…i want the total column to automatically fill the total from another table name activity, for data which falls between the start and end dates selected by the user

In your Total Column, you would inset an expression in the “App Formula” property. That expression would be like this:

SUM(
   SELECT(Your Table[Column to Sum], 
          AND(
              [_THISROW].[Start Date] <= [Row Date Column],
              [_THISROW].[End Date] >= [Row Date Column]          
         )       
   )
)

Be sure to replace the table name and column names with those in your app.

Also, you had said “data which falls between the start and end dates”. Adjust the operators however you see fit for your needs.

2 Likes
2 Likes