-
Formula to Arrive Todays date
Is there any option today reflect today's date in smart sheet. I tried typing =TODAY() in smart sheet cell and returned with #INVALID COLUMN VALUE Its similar to MS Excel I used this formula in the cell I require
-
Can we pause when filling out a Form?
I am creating a Smart Sheet with a lot of data that will be populated via a form. The concern with my team is that if they get interrupted when filling out the form that they will not be able to continue. We have lots of fires to put out so it is highly possible that once started someone may have to step away urgently and…
-
Questions related resource management view
A number of questions. Please provide an "yes/no" answer, following with further elaboration. 1) In the resource management view, the resources are sorted by their names. Is it possible for me to include additional information about the resource (such as department, email, etc.) as a column in the resource management view…
-
Copy Rows Automation Not Firing & Clearing Cell Data
Hello, We are trying to build out a simple employee "check in" sheet that will collect data from all our employees on if they will be in the office, and if so, indicating by a checkbox column. My initial approach was to have a daily, repeating update request automation go out to everyone at 8am every weekday morning (each…
-
How to get checkbox responses to show in notifications?
I have a sheet that has several columns which are formatted as checkboxes and a form for users to submit info. The users check boxes on the form to select fields. I have set it up to send a response back to the submitter with their responses. The notice that goes back to the submitter shows the field names but does not…
-
Workflow for Copy Row is not populating data
I have been using workflows frequently. I have run into the situation where I have a workflow to copy a row to another sheet. Both sheets have the exact same columns. I am sure of that because the second sheet is a duplicate of the first. There is criteria to select the correct row. I ran it once and it worked well. The…
-
Action needed: Add new Smartsheet email domains to your trusted sender list
Hi Smartsheet Community, In the coming weeks, we will start a transition to begin using three new email subdomains to send emails generated by our Smartsheet app; such as automated workflows, sharing, conversation notifications and password resets. We are making this change to follow the email sending best practice of…
-
Using the Duration value in a formula
I am working on a budget for a project plan and want to get the hours associated with a duration to do the math. All of the durations are input as days, i.e. 3d. Is there a way to understand in a formula that this is 24 hours. I have tried to reference the Duration column but am only getting the number the designation of…
-
Is it possible to add any form of Approval / Draft data for a smartsheet, like one would do in Excel
Hi, For compliance I really need to add Draft, Review and Approved data to a Smartsheet, by when and whom etc, like you might get on many document. I am actually trying to do a risk assessment, and had it in Excel, but I find some Smartsheet very helpful. In Excel one would just had a table on another worksheet with the…
-
COUNTIF AND Statement
Hi, it's me again.. I promise that one day I will understand SmartSheet formulas :) Trying to COUNTIF the Status is Complete AND the Phase is Rollout (will need to do this for the other four phases) =IF(AND([Status]@row <= “Complete”(), Phase@row = “Rollout”)) ^^ Does not work Tried to select the range on the sheet as…