-
Scripts/Formulas suddenly not working
Does anyone have knowledge if the roll out of Table View is causing syntax issues with the SS formula operators, or anything for that matter? I've been using one thread for the last two years, I went to update it today, and I keep getting Incorrect Argument Error and Unparsable errors. Below is the formula that has been…
-
Issue displaying certain symbols in formulas
I have the following three formulas in the same column of my sheet that I reference in a dashboard: =INDEX(Accomplishments:Accomplishments, MATCH("current", [Report Class]:[Report Class], 0)) =INDEX([RYG Overall]:[RYG Overall], MATCH("Current", [Report Class]:[Report Class], 0)) =INDEX([Overall Trending]:[Overall…
-
Locking an Original Due Date cell
Hello, I have a sheet that contains a column for Original Due Date and Current Due Date. The Project Manager adds the Current Due Date when submitting the RAID item to the sheet. Is there a way if the Project Manager needs to update the date in the Current Due Date column, that I could copy that date to the Original Due…
-
There are issues with both the sheet formulas and the reports. Could you please check this?
I am posting here because our team is facing a critical issue and we've been unable to use our sheets for several days now. We are currently on a Business Plan and have already submitted three official support tickets through the AI assistant , but unfortunately, we haven't been able to reach a Smartsheet engineer or…
-
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…
-
Converting military time to standard time
Hi All, I have a bit of a different ask than what I saw already listed here. 1. I need to subtract a certain number of hours from a military time format and add it to a third column. Please let me know if you can assist. Thank you!
-
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…
-
How do you spread activity hours across weeks for a resource forecast?
Hi all — hoping someone has solved this before I go and reinvent it badly. What I have One row per project activity in a sheet, with columns for: • Developer hours • Design hours • PM hours • Service type/Milestone • Start date • End date What I want A weekly resource forecast — week commencing across the columns, service…