-
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…
-
What can I add to return a blank if the cell referencing is blank?
I have a formula that pulls in some information from another sheet. =INDEX({Function}, MATCH([Support Manager (email)]@row, {Assigned}, 0)). The formula works fine except that I want it to return a blank if the "Support Manager (email)" is blank. Unfortunately the "Assigned" columns in the sheet it is referencing has…
-
Automatically Add recent changes information to a row.
Hello, I'm trying to look If there is an option to automatically update the changes happened in the worksheet from past 10 days in to new column (Lets assume the column name is "History_Past10Days") Information I'm looking in this column(History_Past10Days): All the column Names updated from past 10 days Ex: Sheet has 20…
-
Formula
Hello, I am trying to find a formula that will allow me to have a count of running occurrences. For example, on the first occurrence of “A”, a 1 will show, then 2 for the second; 3 for the third occurrence, and so on. I know in Excel I can use COUNTIF, but when I try it in Smartsheet it returns the total number of…