-
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…
-
SUMIF question
Hello all! I am trying to update a SUMIF formula to sum a column's data for multiple names. It appears each time it will only include 1 name (POC) which is alphabetically first for the formula. =SUMIF({Sort QPP - Q1 2023v2 (POC)}, [Column2]7, {Sort QPP - Q1 2023v2 (Feb Month)}) Thank you.
-
Formula or Conditional Formatting for Expiration Date Tracker
Hello, I am creating a tracker to track annual and 2 year registrations. I am trying to figure out: If the Registration frequency is annual, how to make the expiration date 1 year from the effective date. If the expiration date is 30 days or less, turn the status cell yellow If the expiration date is 31 days or more, turn…
