-
Column time format
This is a question and a requests depends In our company we want to use columns to track time in this format 9:15 or 10:45 .....etc and the formats doesnt include time. I see the announcment saying time in mins .....etc however maybe this is in Gantt enabled where there are two dates.... we just want to have time formatβ¦
-
How do I write a countif nested formula?
Hi All, I have looked in the forumula info and I think what I have written will do what I need but it is not working. I want to count all the times my Ward column is 1 and then my Assistance column says survey. This is my formula: ="Ward 1=" + COUNTIFS(Ward:Ward, "1", [Assistance 1]:[Assistance 1], "Survey") The correctβ¦
-
How do I reuse column definitions? (like a common drop down list)
Is there a way to define a common drop down list to use across many sheets? So let's say Task Status, we want Not Started, In Progress, In Review, Complete, Deferred. Or something like that, but I want it to be defined in one place and not have to redefine it in every sheet. Partially so if the values change in the futureβ¦
-
Update requests and locked cells
Currently when I send an update request the users can not edit locked columns even if they are Admin status. Is this something Smartsheet is working on? I have managers that I send update requests to and they can not simply click on the locked columns even though they are Admins on the source sheet which bascially makesβ¦
-
Overview page
Is there one comprehensive overview page that let's you view one Gantt chart or one traffic page for all players in all projects? For instance, this kind of overview page would be extremely helpful to agency-wide traffic or project managers to view who had availability and when.Β
-
Mobile + Smartsheet | What's your story?
I'm in Marketing at Smartsheet and looking for examples of how our customers are using Smartsheet on Mobile devices (phone, tablet). If you're using Smartsheet daily on mobile I would like to know more about what you do and how you do it. Three quick questions: 1. Describe your process before Mobile + Smartsheet 2. Whatβ¦
-
Maintain dependencies with manual date
Is it possible to have a task be dependent FS on another task, but manually change the start date? I did this all the time in Project, and just realized in Smartsheet it is breaking the dependency when I try to put in a manual start date. I want to show on a gantt chart there is a dependency, even if the second task is notβ¦
-
Conditional Contact Information
Does anyone know if it's possible to set it up so that when certain drop down selections on the form are checked then it assigns a contact to our "Request Owner" column?
-
gantt chart
How do I get the task to display on the gant chart
-
Update Requests status issue
Hi. I sent an update request, updates were made, but status haven`t changed, still shows as "pending". How can I solve this issue? Thanks in advance.