Sign in to join the conversation:
=SUMIF('Invoice Log'!B$4:B$10405,E22,'Invoice Log'!E$4:E$10405)
I have two sheets. One is a log and the other is entitled "Invoice Log" . I'm trying to do the same in Smartsheet but i'm still getting the error Unparseable.
Hello,
Cross-sheet formulas work differently in Smartsheet than excel. Please check out our help article for more information on how to create a cross-sheet formula in Smartsheet: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
I'd also recommend checking out our article on creating formulas for details on how formulas work in Smartsheet (there are some differences between Smartsheet formula construction and excel): https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet
Also, here's our complete functions list in Smartsheet: https://help.smartsheet.com/functions
Let me know if you're still having issues rebuilding this function in Smartsheet after reviewing the above.
I am trying to change owner on a Smartsheet sheet to the owner of the workspace it is located in. I keep getting an error message stating the permissions need to be managed at the workspace level. I am unable to change owner for the sheet at the workspace level. Not sure how to accomplish this change. HELP!
Hello all, I have a weekly report that I'm building and would like to be able to only expose two weeks worth of status. The report has a status and a commit date column and I'd like to remove anything that is "Done" and more than 2 weeks old. I'm trying to avoid having a report that has 100 rows of tasks that have been…
Is it possible to sort a report widget in dashboards? We have data that could be sorted by date or by location name depending on the use case. Is this possible? I know the underlying sheet can be sorted by column, but I can't see a way to sort the data in the report widget.
