-
How to auto update status based on Newt review date column
How to auto-update Review status Column based on New Review date column. I currently have this formula which gives me pass due or coming due marked as Due for Review and Completed. I would also like to have the status of draft when date is blank, how would i add that to the formula or this there another formual i can use.…
-
Creating Logic from Dropdown List Multi-Select
It would be beneficial if there was a way to create logic in relationship to values from a dropdown multi-select list. For example I am creating a form for judges that will be staying in a hotel. In the drop down multi select they are offered only certain nights in the hotel such as Monday, Tuesday, Wednesday, or No Hotel…
-
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…
-
Reference Sheet locked to another row?
I have a budget sheet with columns projecting salary spending each month over 2 fiscal years. My reference sheet is a salary spreadsheet that has columns for FY(fiscal year) 27 salaries and FY28 salaries (which includes a 3% raise). On my budget sheet, anytime I try to change the reference for FY28 salaries with the 3%…
-
Case open 10 days with no engineer assigned - is this normal on Business? (Case #09786267)
Our account has been broken since Aug 13. Every cross-sheet reference returns #REF, dashboards cannot reach their source reports, and creating a new reference fails outright. 94 sheets and 11 dashboards are affected, and the work that depends on them is blocked. Case #09786267 was opened on Aug 14. Since then: Aug 14…
-
Auto populate previous child tasks
I would like to understand if its possible for child tasks to automatically populate 100% if later tasks are 100% before others. Example in the picture. The third task is 100%. Can the first two tasks at 0% automatically be changed to 100%?
-
assistance needed to pull data from another sheet based on a group field matching in both sheets.
Sheet 1-show and % complete sheet 2-show a column for % complete I want to pull from the other sheet based on the show number and order number. I just can't figure out what is the best way to do that.
-
checkmark formula based on status in another column
Hello All, I created this formula but it does not seem to place a checkmark where it should. =IF([CR CAH STRAT ADMIN STATUS]@row = "2. LICENSE REVIEW COMPLETE - ADMIN", 1, 0) It leaves it blank when this is the status in that column. Any ideas?
-
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…