-
hh:mm:ss format??
I am logging time spent per job using timesheet software, and the data it exports is in hh:mm:ss format. Is this date useable in Smartsheet? From this, I want to calculate a job cost. In Excel, I would do this by using the following formula: = hh:mm:ss x hourly rate x hours in a day (24) This would give me a £ value for…
-
If statement for checkboxes
Hey everyone, I have project schedules with milestones that have associated tasks for each. (i.e. releasing a drawing set includes getting it stamped, sending to subcontractors, etc). I would like to make the tasks a checklist that would populate the percent complete (instead of a harvey ball), using a formula. Has anyone…
-
Percentage Formulas and adding to SIGHTS
Hi, I am trying to use a formula based off of Counts or Sum to get a percentage of work done. Then I need to add that percentage into my SIGHTS Dashboard. I am having trouble finding an operator or formula to help me do this. Does anyone know how to best solve this issue? Thanks!
-
Is there a way to remove someone from Resource View without removing them from a project?
Unfortunately people come and go. They are assigned tasks, work on projects, etc and then if they leave, they need to be removed from the Resource View. Reassigning future tasks is acceptable, but we need the history and want to keep them listed on completed tasks. Is there a way to do this? I would rather not have to…
-
How to calculate the Actual Duration only when the Actual Start and Actual Finish have values?
Hi, I'm working on a Smartsheet of which two of the columns are "Actual Start" and "Actual Finish". I have a third column called "Actual Duration (days)". Both the "Actual Start" and "Actual Finish" columns are date type columns and "Actual Duration (days)" is a Text/Number type column. What I want to have happen is as…
-
Google form → SmartSheet → E-mail Alert
I created a google form that is linked to a smartsheet. (I had to create a google form because smartsheet doesn't have a multicheck option available for the web form capability). I'd like to use the alerts capabilities of SmartSheet so when someone fills out the google form, the answers to go the smartsheet, and it will…
-
Duration calculation issue
I don't know if it is bug or feature, but it looks strange for me. So I have sheet created based on project template. I have dependency turned on. I noticed next behaviour: If task start at weekend or holiday then duration calculated with one extra day. On attached image all tasks (except task2) have wrong value in…
-
Tracking New Smartsheets - How to request and track the sheets
Has anyone worked on a SS template for users to request/update new Smartsheets? I could use a standard ITSM ticket tracking system, but I'm leaning toward a webform users fill out to request a new Smartsheet. I could use the functionality of SS to communicate updates, gather requirements, and discuss other SS request…
-
Can a Licensed User in the Team Plan view the Admins workspaces and Sheets?
Hi, I've purchased the team plan and apart from me, I've added another project manager from my team as a licensed user so she can create sheets. This puts me at 2 of the 3 licensed users. My question is that can I prevent her from view a specific workspace in the account because even though she is a licensed user on my…
-
Suggestions ??? - Menu with links to other sheets
I don't want to get too complicated with my design, but I would like to build a small menu in the upper left corner of my project sheets to help the PMs navigate quickly between sheets (opened and closed). The only snagged I ran into is having a menu on a report that can switch back to a sheet. I'm just adding hyperlink…
