-
If Statement with nested VLOOKUP formula
Hi! I would like to return a value from another SmartSheet if one column in that same SmartSheet has a "Y". I have the current formula below, but it's returning a #NO MATCH error... any thoughts? In summary: return value in column A of SmartSheet Y to SmartSheet X if coulumb B in SmartSheet Y = Yes.…
-
Calculation within IF statement
Hello, I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVALID DATA TYPE" and I tried to use to IF statement to do that - If completion date is blank, leave the cell blank, otherwise…
-
Simple row multiplication formula
Hey all. Looking to have a row for an MSRP where the row shows the suggest 15% markup on a row. For example say row named COST is $100 and I want a markup of 15%, I want to create a formula to multiple COST row * 15% I am multiplying 1 row by a fixed number. I am not multiplying two rows together. What's the correct way to…
-
Simple sell date - buy date formula
Hey all. Trying to do a column equation that shows how long an item has been sitting on a shelf. Lets call the two columns Sell Date and Buy Date. I'd like to see the amount of days between Sell Date and Buy Date. If I bought inventory on 1/1 and sold it on 1/10, I'd like it to read "9' for "Days on Shelf" column. What's…
-
% Formula
Hello, I am trying to calculate the % complete within the "Status" column. I have Task labeled "In progress" "Not Started" "Complete" and "N/A". I have Sum formulas set up to tell me how many are complete etc but am looking for a percentage. Any advice ?
-
Is it possible to get the reference of the First Parent ?
I would like to extract the sub-parts whose biggest Parent is called Media communications. Is there any function that allow us to extract the name of the biggest parent instead of the closer one ? =Parent(Example@row)
-
Count if checkbox is checked in each week of the year.
Hi I'd like to count a row if a checkbox is checked within a specific time frame. e.g. If Column 'Role' is "LMS" and column 'Complete' during a specific time period (e.g. week 6 of the year), count as 1. =COUNTIF(Complete:Complete, Role:Role, "LMS", Complete:Complete, "1", WeekNumber=6) I've been playing with various…
-
Combining an IF / MIN Formula
I am using a COUNT IF / MIN formula to pull in the next upcoming date based on a specific name within a range, but the formula I have is not working. Here is the situation: Sheet 1: A sheet for an individual client's open cases. Sheet 2: A sheet that includes milestone dates for ALL clients. I would like the ability to…
-
How to Send Timed Reminders Based on a Trigger?
Hi, everyone; first post, Intermediate user. I'm hoping you can help me. I've set up a SS to send an approval request when a new line is added to the sheet from a form entry. I've got the automation figured out for approval or declination. I'd like to send reminders if no one answers that approval, though. What I'd like to…
-
Index Match formula returning #NOMATCH, can search type be a formula?
I am attempting to create an Index(Match( formula to pull job names based on a job number, but I am getting a #NO MATCH error. I have used this formula hundreds of times, so I am wondering if this is because my Match search type pulls from a cell that is also a formula?? Any workarounds? This is my sheet, I want to use the…