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.
We want to implement single-sign-on at work and have received approval. However, our IT department wants all external partners to have/use Mayo credentials to log into Smartsheet. Not all of our external partners ever set foot on our campus and don't have our company credentials. I have a couple of questions. Has any other…
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Cant find this anywhere
