-
IF Formula working on some and not on other items in column
Hi All, I have a formula running in a column to validate an action based on whether it was done prior to 01/01/2011 or not. =IF([Install Date]@row >= 1 / 1 / 11, "Yes", "No") The formula works as required on rows where there is a year only, but throws #INVALID OPERATION where a date has been entered through smartsheets…
-
Record a date - From/To
I am trying to record a date when the value in a status column changes from "Closed" to anything else. My research shows that I should be able to create an automation using the condition Status Changes From Closed to Any Value, if the status field is a single select drop down field. I've confirmed the status field is a…
-
Update requests not showing up
Has anyone experienced an issue with Update Requests not showing the icon but still going out to the parties that it should? (We refreshed and did a Ctrl + F5 reset) We have experienced a ton of these and while it is only a graphical issue for checking status's this gets confusing. ~MR
-
Multi-Project Gantt Chart with 1 Swimlane Per Project
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
-
Flagging Tasks as 'Blocked' if Predecessors are past due
Hi everyone! New to Smartsheet and trying to build some features for my company. I've been doing a lot of reading and tutorials, and I think I'm close to the end of this problem. Like the title says, if a task goes past its due date, I would all of its dependents tasks to flip to 'Blocked' status. I made it so far as to…
-
Auto Number column will not reset
I need to reset my auto number schema to a different format. However, when I do, all new rows still use the old format and continue with the same numbering. I have tried deleting the column, saving and recreating but it does not work. I have also tried the web version and desktop app and get the same results. I have…
-
Recover file
Hi, I want to revover an file that i delete by mistake. How can I recover it?
-
Owner of the sheets but only have Viewer access right
I have subscripted Pro user plan and currently work on 3 sheets. Two of the sheets suddenly not allow me to EDIT and I can see I only a Viewer of the sheet, but actually I am the only member of the plan. Really don't know how to fix the access right to be admin of those sheets.
-
Not able to allow/update permission for my members to access smartsheet
My colleague had a viewer access. Then updated the access to editor-can share. But the access not updated. The account doesnt change to provisional member its still viewer. Anyone else facing this issue ?
-
Cell values automatically reverting to previous values. Changes won't save.
I have a very serious concern. I am updating the contacts column to change the contact from Richard to Teresa. However, after about 10-15 minutes Smartsheet automatically reverts to the original contact. This has been happening for a week . I am very concerned because how can I be assured that changes are saved in all my…