-
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…
-
How to fix INVAID DATA TYPE, referencing start and end dates, & duration to calculate % complete
I am using a project sheet with the formula below to calculate the % complete based on the duration of the task, and start and finish dates. However, if there are not dates in the start and finish column I am getting an INVALID DATA TYPE error. I've tried using IFERROR in my equation but I cannot get it to work. I plan to…
-
Multiple formula
Hello everyone, I tried to use multiple formulas, but for some reason it is working together (one-by-one they are working). What I want to do with this: I have a machine checking sheet, where the sheet send me a notification, if I work with any of my machines. Every machine has a group nr (1-5), what defines ow often I…
-
How do I add a third argument to countifs formula?
I am trying to only show dashboard data from the sheet IF the submitted date is from the current year - we do have a helper column for the submitted year but I am unsure how to incorporate it within my formula below. I am trying to count if the status is Working, Next up- top opportunities, Pilot/implemented,…
-
Formula to extract a date from a cell that includes both text & date
The cell in our sheet has "Completion Date: MM/DD/YYYY". In the sheet summary, what is the formula to pull just the date from that cell/field? Thank you!
-
Formula issue showing 0-5 Stars
Can anyone identify the error in this formula - it should show "Three" stars in the column as it's counting 3 true checkbox cells. However it will only return the "Empty" stars result. Obviously the number of stars formula result is based on how many boxes are checked.
-
Check inventory in two columns and change symbol column.
Hello all ! I have a challenge for you guys. I have a sheet where we book groups for a venue. Some of those groups will also book a space for a cocktail before the show. There are 3 spots available per day for a cocktail. I would like to have a column that tells me if the cocktail area is available for that date. I guess I…
-
Counting blank cells when other criteria is met
Hi, I need to add on top of a formula that counts tasks that are in progress or not started that are past due. The formula below works for that, but now I also need my total to include cells in the target completion date that are blank. =COUNTIFS(Status129:Status144, OR(@cell = "In Progress", @cell = "Not Started"),…