Is is possible to write a formula based on information in one sheet to put the result in a cell of another sheet?
I want to sum items if they meet certain criteria in one sheet but the result going in a cell in another sheet.
Thanks!
Yes, it is using cross sheet formulas. Check out these articles/videos for more information:
Thank you!
I have an automation set up so that when the Status column changes to Complete, Canceled, or Not Needed, Smartsheet automatically updates the % Complete column to 100% (Text/Number column type). After that, another workflow should trigger to alert the next person that their task is ready. This worked fine before, but…
I'm working on a formula that will return a count based on a matching dates and the word "Quality", but I'm getting the unparseable error. I'm sure it has to do with where I'm putting the ) and ,0 ,1. Here are some that I have tried:
I need help creating a formula that references the "Due in Payroll" column I have which is a series of dates. I would like the formula to look at that date column, and return whichever date in that column is closest to today's date. I've tried several formulas, all come up invalid column type, unparseable invalid…
