Sign in to join the conversation:
How do I do this?
If my column A status (dropdown) is Pay Supplier I want it to then tally the column "amount due" with that status.
Thanks
Try something like this...
Â
=IF([Column A]@row = "Pay Supplier", SUMIFS([Column B]:[Column B], [Column A]:[Column A], "Pay Supplier"))
I am trying to replicate a Kata chart in Smartsheet and need help.
I have an automation set up to email certain team members if values change on a sheet. The trigger is set to Daily so that it doesn't send them a bunch of emails every time I add data. What I want to know is, at what time do these usually run? I want to make sure that it is not sending out the email before I have finished…
What is a formula to count the # of tasks that are overdue, based on a date?
