-
Task Status Autofill based on % Complete and On Hold Flag
Hello, I would like to autofill my task status column to "Not Started", "In Progress", "Completed", or "On Hold". Not started, In progress, and completed would be based off a completion %, and On Hold would be based off a flag called "On Hold". I would like to keep this flag so we can use it for roll ups in our dashboards…
-
Formula not returning value as expected
Hi all and help! I have made a formula to check a box when there is a duplicate ID Number in my sheet. But the box is getting checked when I add any new row to my sheet. I've tried to find where I'm going wrong and can't seem to find it. Can someone with fresh eyes lend a hand? Here's a snippy of what I have going on:…
-
IF formula - If two columns are the same then return "No"
I'm trying to write a simple formula but receiving an error. Help? If two columns are the same then return "No" =IF([Estimated number of participants]@row=[Confirmed Anticipated Volume]@row, “No”, “Yes”)
-
IF AND statements looking at two columns
I think I need an AND statement but not sure exactly how to do it. I have a R/Y/G column that I need to have check 2 other columns to determine if it should be Red or Green. I would like to be notified if an invoice has not been paid. Current columns: 1) date of when the invoice is sent to Finance; 2) take col 1 and add 21…
-
IF formula question....
Hello! I am super brand new to SmartSheet! I have a column called "Injury" and there is a drop down so either "none, associate, or driver" can be selected. If "none" is selected, I wanted it to automatically apply no to other columns. Probably the most simple thing to do. I haven't started any training yet. Thanks! Jen
-
How do I Automate a Checkmark IF another cell is a certain value
Hi All, I am trying to automate a checkmark in a checkbox column if the function returns ANY of the dropdown values from another column. For instance, If the Project Team (Column) assigned is either "DPMO", "Engineering", or "Clinical Effectiveness", I want the cell to have a checkmark ("1). If it has anything else, I…
-
Avoiding (email) notifications if assigned to = modified by
Hi all, I have set up a market research project plan with around 60 tasks. Each task is assigned to specific person(s) (could be multiple). I have a workflow where they 'assigned to' contact receives a (email) notification if the row on which he/she is 'assigned to' is changed. However, I only want them to receive (email)…
-
We are attempting to make a column from 1 sheet auto fill onto a second sheet and add new rows
We are making a database. We made a sheet for this (AllJobs3) and are attempting to have this sheet pull the Primary Column from a master sheet (All41). We only want the primary column as the database doesn't require all fields. We have been messing with INDEX(COLLECT), INDEX(MATCH), & VLOOKUP but we cannot seem to get it…
-
How to add multiple status criteria when counting tasks
I am looking to create two summary sheet fields. Formula 1. Count the number of tasks that are due within the next 14 days Constraints: Status must be "Not Started, In Progress, OR Scheduled Due Date must be within the next 14 days Formula 2. Count the number of tasks that are due within the next 14 days but also return…
-
Form - Restrict input of a past date
Hi, I am re-opening this question to know if any updates have been made since? The question is related to the Smartsheet Form, on having an option to restrict a sender from being able to enter a past date in a form. Related discussion open a few years ago in this question 'Web Form - Disallow Past Dates?'. Thanks, Manuel