-
Start and End date editing on my Ipad
I’m new to Smartsheet. I’m using an iPad Air to schedule construction projects for my company. In the Gantt view when I attempt to edit Start and End dates, the windows for them appear gray and it will not allow me to edit them. The other editing options windows are white and they allow editing. I am an admin in our…
-
Dashboard - Report Column Widths look ridiculous
I have a report that feeds into a dashboard with 8 columns: * At Risk (flag column) * Health * Task Name * Assigned to * Status * Progress Bar * Start Date * End Date Why does it stretch that last column (end date) so wide? It looks ridiculous. The At Risk flag columns is a very appropriate size for the content. So it the…
-
Card View Conversations
What am i missing, Card view is a superb feature of SS and starting to use lots, however when you add a task or subtask there is not an option to start a conversation, you have to go back to grid view for this. further more where there is a conversation in grid view the conversation box comes up when you open in card view…
-
Formula Question
I would like the column "Done" to be checked automatically if the % Complete is changed to 100%. I am using the formula below which is not working: =IF([% Complete]3 = "100%", 1) Any suggestions?
-
Nested IF Statement for Flagging Duplicates
Hi, I am looking to create a nested IF statement that allows me to look at multiple columns for duplicates. It is only true if there is a duplicate in each of the columns. For Example: First Last Job Jeff Smith Programmer Jeff Smith Designer Jeff Smith Designer In this scenario, I want a flag checked off when ALL 3 appear…
-
How to Set My Weekly Update Request Form to Blank Cells before the Weekly Update Request?
Hello, I would like for this form to go completely blank on ALL cell-rows before the update request gets sent to the collaborators (not licensed users) every week. I already have the update request set to send every Friday at 9AM to request the form to be filled by the list of collaborators. I just want to make sure the…
-
Formulas Referencing Another Sheet
Hi, am working from a running sheet that currently has formulas but I'm trying to put the formulas into separate sheets so I can run metrics in a slightly different way and try to make the running sheet more efficient. However, whenever I type the exact same formula, with the only difference being referencing another sheet…
-
Project schedules with fix dates
Some of the tasks in my Smartsheet project have fixed dates that can't change dynamically ( ie, scheduled training sessions ). I'd still like to list them as dependencies for other tasks. I'm assuming there is no way to do this, based on other discussions about being unable to fix dates for tasks. I don't see how complex…
-
Automatic "Cell linking"
*What would be the best way to create a permanent link between cells. What I want is that if the user knows one of the bits of information, i.e. "WXP" that the other 3 cells get filled in automatically. We basically develop real estate and the project might start out known as the "Nome project" and gets assigned a Project…
-
Help with #DIVIDE BY ZERO error message
Hello, Hoping you might be able to assist me with a similar issue I'm experiencing. I've attempted to import a Trello board into Smartsheet for one of my colleagues and I'm getting the same error message, when I view it in grid view on some of the rows. The formula in question that is currently being used…
