-
Is there a way to validate that a particular cell cannot be left blank or allow junk entries?
In our application, we have the smartsheet as the user interface to enter the data and then this data gets transported into the database by an API according to a set cadence. For data integrity purposes, I want to ensure that certain key fields should not be left blank or allowed junk values.
-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…
-
Issue in sending update request
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…
-
Formulas Referencing Another Sheet
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…
-
Nested IF Statement
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…
-
Average days returns 1 value if 0 and the average value if >0
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…
-
Summary Fields: Percentage of Completed Checkboxes
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…
-
Inventory
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.
-
Capturing the Date and Time a Cell in Smartsheet was created or modified?
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.
-
How to Create A Template Set
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??