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"))
Hi There, I am looking for any description on Roles and Permission with the new USM. Are there any changes on the Roles and Permissions compared to the former license model? As an example I am especially looking for the User Management Roles (e.g. Group Admin, Resource viewer, Plan Asset Admin) as well as the Workspace…
Hi Smartsheet team and community, Is there a chance you could consider adding these two features to make our workflow smoother? 1. Add Instructions to "Request Updates" Automation It would be incredibly helpful if we could include a short description or set of instructions when sending an “Update Request.” That way, when…
Hi, I'm trying to figure out how to preserve cell data BEFORE an Update Request is executed. I was hoping to find functionality that would allow me to change the value of a cell in helper column WITH the value of the cell that is going to be updated once the Update Request is sent and subsequently executed.