-
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…
-
Calling Custom APIs from Smartsheet form
Hi All, we have a simply custom API which will take as input an employees ID and return their management chain. We would like to call this API as part of a simple smartsheet form we built such that their supervisor's ID can be inserted as part of the record in the smartsheet. Are there instructions as to how to embed a…
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…