-
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
-
Adding Contacts to Primary Sheet From Bulk Upload Sheet
Hi, I am working on a Huddle Board solution using swim lanes. These are keyed off of a Primary Responsible Contact column with the contacts listed out in the background for selection. Part of this solution will allow to visualize standard work versus ad hoc. To get all of the standard work loaded each month, my best…
-
workspaces and templates not appearing in Zapier
I am the owner of the workspaces and templates - Admittedly I do not know if this in on the Zapier side, but I seem to be missing several options when using Zaps to create new sheets from a template. The system does not see the destination (workspace) I want to new sheet to go in, nor the template I want it to create. What…
-
Workflow with Two Conditional Statements Not Firing
I am trying to create a workflow that will send one daily notification of all rows that meet one of two criteria. In simplified terms here is the logic I have: If Department = A, B or C AND Manager Approval = Approved OR Department = D AND Executive Approval = Approved THEN include in daily notification email. The problem…
-
Add clickable "hyperlinked" text to an Update Request Message
How can add clickable "hyperlinked" text to an Update Request Message Change this Click http://www.ebay.com to be taken to the link To this Click HERE to be taken to the link The html code is <A HREF="http://www.ebay.com">This will show as clickable</A>
-
Automation: Send to contacts in a cell
Hi, I'm having an issue where an automation won't send an email. My personal settings are correct. It will send the email if I input an email address, but it will not dynamically pull that email from the submission. I.e, it's a mutliple form, and the form gets filled out by X person, who inputs into one of the contact…