-
Weekday Formula Error?
Hello all! I've been trying to create a time entry sheet like many others, but am running into an error with the Weekday() formula. I'm using the formula on a system column for the date/time the row was created. I have an entry for 01/22/18 4:20 PM, which returns "2" for the weekday value. Right after I have an entry…
-
Setting up Days Outstanding
Hi all! I need to fix a column in Smartsheet. The column that says "# of days outstanding" does not always automatically fill for us. How do I fix this, do I have to put a formula in each cell? Also, smartsheet newbie here, I've been working in it for about a week, so I might need extra help. Thanks in advance! Laura
-
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?