-
Is there a way to get the date into metric sheet
I want to copy the preferred delivery date to metric sheet as per today's date Is there a way I can show this dates in metric sheet. I tried Index match formula but its not working in this case as there will more orders for the same product name. Please help me to solve this
-
Looking for a formula that uses status and finish to calculate health.
Hello Smartsheet experts, I am trying to write a formula that accomplishes the following in a health column with the Red, Yellow, Green, and Blue options... Status "Complete" = Green Status "On Hold" = Blue Finish "Blank"(or "") = "Blank"(or "") Status "In Progress" AND Finish is greater than Today, Green Status "In…
-
ISBLANK Formula for Early, On-Time, Late Tasks
Hi there, Thanks in advance for the help. I would love to be able to have the "Completion" column show as blank if the "Target Release" cell is also blank. Here's what I have written now: Somehow I need to be using "ISBLANK" but I am not sure how to nest it. Thanks so much, Ian
-
Calculate new contract amount when change order is approved.
I need a formula that will calculate 'New Contract Total' (Original Contract + Change Order Amount) WHEN Status = Approved.
-
Copy cell value from one column to another
What formula would be best to use, to copy the cell value from the Employee Name column to the blank Name column?
-
Count IF formula that meets multiple criteria.
I am looking to get an accurate count of someone’s workload. I want to count if a specific person’s workload meets multiple stage criterion such as “Execution” and “Planning” The Support Required column is a contact list. The Stage column in a dropdown list. I am pulling this information into a separate sheet hence the {}…
-
Multiple IF Statements
Can we do multiple IF statements? I've tried to use IF and also OR to complete the function I'm trying to do and nothing seems to work. I want my Status column, "Not Started", "In Progress", and "Completed" to be based off of the % indicated in the % Completed column so I don't have to remember to change the status when…
-
Formula to check box if cell contains Date OR Text
I have a nested formula that currently involves one check box be checked and three date columns to contain dates in order to check-mark as 'Complete.' However, I discovered one of the date columns involved may contain text from time to time (as a date is not always applicable to this particular field). How can I revise my…
-
How can I calculate the total days of a column when another column meets a criterion?
Hi everyone, I need help creating a formula that collects the total days from the date a request is inputted to the day it changes from "Pending" to "Approved". Dates are registered in the column "Date Initiated" Status is registered in the column "Review" I created a "Today's Date" column to subtract the requested date…
-
index/match formula that returns image instead of file name
has anyone been able to come up with a formula to return the actual image instead of the file name? i tried index/match but wasn't successful. found a few previous posts re: vlookup and data mesh that shared similar struggle. 2018 https://community.smartsheet.com/discussion/29921/vlookup-of-image 2020…
