Sign in to join the conversation:
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’m trying to confirm if it’s possible to calculate an Event End Time based on our current fields. We have a report that we pull into Smartsheet On Smartsheet: Request Start Time (Duration) Duration (duration field in minutes) Event End Time: (Duration) Formula's that I tried: =[Event Start Time]@row + ([Duration]@row /…
Hi there - I'm in need of a little help with a formula for a metrics sheet I'm creating. Metrics sheet looks like this: And I'd like the Units cell to display the a count of how many times a ID Number shows up in another sheet for the month and the year. In this case, the result for Jan 2025 would be 7 (since EQN187742 is…
Hi, I am having trouble to make the Indexx Match work. Can anyone spend a few minutes with me to help?? penny.krug@pattersonvet.com Thank you Penny
