Formulas

NOT a formula question - every cross-sheet reference in our account died on Aug 13, and reports/dashboards broke too
This is not a formula syntax problem. Our formulas are unchanged and correct. Smartsheet simply can no longer resolve references to other objects in our account. Since Aug 13, every cross-sheet reference across the entire account returns #REF / #INVALID REF / #BLOCKED. Formulas inside a single sheet still work fine. It is…
Account-wide: cannot create ANY cross-sheet reference, all linked formulas #REF, Owner treated as Editor
Since Aug 13 our entire account (Business plan) has been unable to use cross-sheet references at all. A support case is open but no engineer has been available yet, so I'm hoping someone here has seen this before. WHAT'S HAPPENING Every formula using a cross-sheet reference returns #REF (some show #INVALID REF or…
Remove a formula from an entire column
My company have an ongoing issue with one of our shared Smartsheet's - the dates keep switching to American style even though we paste them from a spreadsheet into the Smartsheet in the English format. We then individually have to change them to UK, and they keep turning back to American. I have had a google and a play…
Level of Effort Resourcing
I’m looking for a Smartsheet-based solution to track level of effort (LOE), resource capacity, workload, and percentage allocation to specific tasks. My goal is to accomplish this using formulas, templates, and native Smartsheet functionality that can be incorporated into our existing environment. I understand Smartsheet…
Request for More Details About best Courses available in Smartsheet University
Hi, can anyone suggest some of the best courses available in Smartsheet University? I’m a working Data Analyst and want to explore more advanced Smartsheet features, especially: New updates and features Control Center Advanced formulas and functions Advanced automation tips Any course recommendations would be helpful
How to create a timestamp that can't be changed once it's been populated
I would like to create a timestamp that records the time and date the first time a cell is populated, and never changes after that. This can be done in Excel with VBA code. Can this be done in Smartsheet? Also, this cell should remain blank if the reference cell is blank.
Need formula that converts HH:MM:SS to total seconds
HI, Seeking formula assist. I have to collect monthly stats that inlcude HH:MM:SS, however I am unable to average a full quarter in smartsheet becasue this format, HH:MM:SS is deemed text. 1- What is the formula needed in the helper column to convert HH:MM:SS shown in column labeled JAN into seconds in the helper column 2-…
How to Set up so Formula's Don't Autofill
I created a SmartSheet that has various formulas based on the task and its deadline. When a new entry is added, the formula autofills, which we don't want. The preference would be to have it blank so that when the admin in charge of managing the sheet goes into it, they know its a new entry and they need to add the…
Linking values in columns across sheets
Hello. I have a column in one sheet that I would like to copy over into another sheet. I would like this to automatically update when the source sheet is updated, but when I tried just implementing a formula that would set the values of the new column to the source column (with a reference to the other sheet) like in…
How do I prevent all the formulas in a column from changing to the same cross-reference?
Up until yesterday this was working - infuriating! Now when I change the cross-reference in one formula in a column, the rest of the formulas in that column change to the same cross-reference. How do I prevent this from happening?

NOT a formula question - every cross-sheet reference in our account died on Aug 13, and reports/dashboards broke too
This is not a formula syntax problem. Our formulas are unchanged and correct. Smartsheet simply can no longer resolve references to other objects in our account. Since Aug 13, every cross-sheet reference across the entire account returns #REF / #INVALID REF / #BLOCKED. Formulas inside a single sheet still work fine. It is…
Account-wide: cannot create ANY cross-sheet reference, all linked formulas #REF, Owner treated as Editor
Since Aug 13 our entire account (Business plan) has been unable to use cross-sheet references at all. A support case is open but no engineer has been available yet, so I'm hoping someone here has seen this before. WHAT'S HAPPENING Every formula using a cross-sheet reference returns #REF (some show #INVALID REF or…
Remove a formula from an entire column
My company have an ongoing issue with one of our shared Smartsheet's - the dates keep switching to American style even though we paste them from a spreadsheet into the Smartsheet in the English format. We then individually have to change them to UK, and they keep turning back to American. I have had a google and a play…
Level of Effort Resourcing
I’m looking for a Smartsheet-based solution to track level of effort (LOE), resource capacity, workload, and percentage allocation to specific tasks. My goal is to accomplish this using formulas, templates, and native Smartsheet functionality that can be incorporated into our existing environment. I understand Smartsheet…
Request for More Details About best Courses available in Smartsheet University
Hi, can anyone suggest some of the best courses available in Smartsheet University? I’m a working Data Analyst and want to explore more advanced Smartsheet features, especially: New updates and features Control Center Advanced formulas and functions Advanced automation tips Any course recommendations would be helpful
How to create a timestamp that can't be changed once it's been populated
I would like to create a timestamp that records the time and date the first time a cell is populated, and never changes after that. This can be done in Excel with VBA code. Can this be done in Smartsheet? Also, this cell should remain blank if the reference cell is blank.
Need formula that converts HH:MM:SS to total seconds
HI, Seeking formula assist. I have to collect monthly stats that inlcude HH:MM:SS, however I am unable to average a full quarter in smartsheet becasue this format, HH:MM:SS is deemed text. 1- What is the formula needed in the helper column to convert HH:MM:SS shown in column labeled JAN into seconds in the helper column 2-…
How to Set up so Formula's Don't Autofill
I created a SmartSheet that has various formulas based on the task and its deadline. When a new entry is added, the formula autofills, which we don't want. The preference would be to have it blank so that when the admin in charge of managing the sheet goes into it, they know its a new entry and they need to add the…
Linking values in columns across sheets
Hello. I have a column in one sheet that I would like to copy over into another sheet. I would like this to automatically update when the source sheet is updated, but when I tried just implementing a formula that would set the values of the new column to the source column (with a reference to the other sheet) like in…
How do I prevent all the formulas in a column from changing to the same cross-reference?
Up until yesterday this was working - infuriating! Now when I change the cross-reference in one formula in a column, the rest of the formulas in that column change to the same cross-reference. How do I prevent this from happening?

Formulas

Discussion List