Dear Sir, My company has a Business account with Smartsheet with 3 licensed users. The other employees of the company also working with a smartsheet account as a free user. Earlier they are able to send update request from their smartsheet and get updates from other users of smartsheet. But now after updation of software…
Hi, am working from a running sheet that currently has formulas but I'm trying to put the formulas into separate sheets so I can run metrics in a slightly different way and try to make the running sheet more efficient. However, whenever I type the exact same formula, with the only difference being referencing another sheet…
I'm fairly new to Smartsheet and I'm trying to calculate a planned budget based on an "Assigned to" column. I'm getting unparseable, so I'm missing something. Here is what I'm trying to build if someone might help me solve the issue... =IF([Assigned To]@row = "Bob Dole", [Planned Hr]@row * 175), IF([Assigned To]@row = "Abe…
I'm trying to have the value of a cell say same day in the event the average number of days is 0. I want to return the average number of days id greater than zero. Everytime I add an else statement it becomes unparsable. Here is what I have. =IF(AVG({Field Scheduler Test Range 1}), 0, "Same Day", (AVG({Field Scheduler Test…
I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in the children rows) has a checkbox. I have figured out how to calculate the percentage…
Is there a training video to show us how to do the inventory and features? We want to use this feature but I need some training.
How can I capture the date and time the associate column in the above image was created and I want it to be in the date column. Thanks.
I've created several project management files (sheets, reports, dashboards). How can I save these as a template set (package) for others in my organization to use/download? Or is it save as a workspace??
I currently have a large dashboard which is opening about 3/4 of the way down. Is it possible to set so the first view is at the top?
I have a form where my customer can request certification documentation. The form logs in a Smartsheet for tracking requests. The automation sends an update alert out to my team, requesting a response. When they respond to the update alert, they can attach a file. What I would like is for the attachment to be added to the…