-
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-…
-
Payroll Breakup
Hello, I have pay dates on the 15th and the last day each month. A person may be contracted for say 21 days and that pay needs to be parsed out depending on what days that employee worked in that time period. I am having a hard time coming up with an equation for each pay-period cell. Pay, 1/15, 1/31, 2/15....
-
Manpower Tracking with Projects
I am trying to set up a way to track manpower 50+ people plus projects that are ongoing. 2 separate sheets are fine - 1 project summary and 1 manpower. How can i set it up, that i can see who is available, when workers will be on vacation and it will notify is someone is booked for one project so i can't double book them.…
