-
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…
-
Using multiple checkboxes to output a list.
I have a Smartsheet with 7 columns, all with checkboxes....they are tasks for a project. What I'd like to do is summary the tasks (in one cell) based the boxes that were checked. For example, if my boxes are: Take out the trash (checked) Mow the lawn Clean room (checked) Wash dishes (checked) Walk dog (checked) Vacuum car…
-
Count IF formula
I need a formula that will count if days till due are between 0 (today) and the next 7 days AND if the status column is not complete. This is not working for me. =COUNTIFS([Days Till Due]@row > 0, [Days Till Due]@row < 8, ([Status]@row = "Complete", "") Thanks all
-
Required Fields in Forms and Default Value
Hi all, I've run into somekind of strange behaviour on the Form I've developed and was wondering if anyone had any insight into this. Can I make a field required with a default value? It seems that by inputting a default value on the form field, the user is able to submit the form without having to change that value. It's…
-
IF statement with an OR....
I'm pretty new to all of this, and the examples I've viewed are not helping. I have a column two columns and need a third to show a value based off the first two. If a column "grade" = "NBC" and other column has grade "abc" or "def" or "ghi" or "jkl" or "MNO" or "PQR" or STU" or "XYZ", then I need to show the: abc" or…
-
Manually trigger workflows
Hello, A few times my automated workflows are delayed a few hours. They eventually trigger, but i'd like to know if I can manually trigger the workflows myself. Kinda similar to restarting services in windows Thank you in advance, Colin
