-
Conditional formatting and uniquely identifying cells
Hi, I would like to only apply conditional formatting to cells that are percentages. My rules currently set any cells that are over 100% as red, and 100% or less as green. Due to the red rule formatting any cell over 1.01 a lot of my data is showing as red, wheras this really needs to be white, there is no cause to flag…
-
Calculating business (working days) in a Leave Application
I need to know the number of working days ie Monday to Friday for each Leave Application requested by workers. What is the best way to do this as most forms have the Start Date and the Return Date which includes weekends so therefore any formulas to calculate the number of days will not reflect actual work days.
-
Signatures on Forms
I was wondering if there was a function that I could you use to sign forms? I have staff of about 80 who need to sign that they have received Tools of Trade like mobiles. At the moment we are doing this with paper, which gets lost - would love to be able to set up a smart sheet and have everyone saved in the same place and…
-
Locking User Abilities
Hello, Is there a way I can lock down users to they cannot remove each other from a sheet? I would like them to be able to edit the sheet but not be able to remove another colleague. Thank you, Alex
-
Dashboard
Hi, I want to report on the number of form submissions in a dashboard - can anyone tell me if this is possible? Many Thanks
-
Can your event span time in calendar view?
I am using Smartsheet’s Product Release Roadmap form. I added a start date and an end date to the cards so that the projects can span a period of time in the gant view. Is there a way I can make it so they also show as spanning a period of time in the calendar view? Currently, each individual card is only showing as the…
-
Multiple resources - Resource view
Hi, I have multiple resources assigned to the same project same times, how can I use resource management tool to view all the resources if it only allows me to select one column. I have 2 column for resources and would like to use both to accurately have a view of how my resources are being utilized. thanks,
-
How can I generate a project planned vs. actual S curve in smartsheet?
I have a project plan with task name and timelines. I am using the gannt chart template. i want to see an S curve: Planned vs. Actual. Wondering if there is an automated way to generate that?
-
Resource management
I am trying to create a resource management sheet to show who of my resources is busy or not and what his utilization % is. My resources travel to locations and i would like to be able to see in resource view the time that is being used for travel separately from the class time. Appreciate your help, Aldina
-
not able to paste to the column with ID number
hi, I have removed a number of rows from my smartsheet. now I want to paste the data from another sheet but the system would not allow me to paste to the column with the doc ID number which fills in automatically. I would like to keep the original ID numbers therefore I would like to paste them from another sheet. What can…