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 pull in the contact information of a second HR Business Partner, contingent on the department of the individual, from a separate reference sheet. However, not all departments have a second HRBP— so if the column of "second HRBP contact info" is blank, I don't want anything to be pulled into the new sheet's…
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…
Hello, My index match formula cross sheet is giving error since yesterday. =INDEX({VER DT4DT Tools Range 1}, MATCH([App CI]@row , {VER DT4DT Tools Range 2}, 0)) I have checked the format of columns in both sheet and also retyped formula. any advice?
