-
Monster IF formula for date timeline
Link to the sheet: Trying to make a sheet that auto populates a timeline of dates based on two columns that have multiple options. The formula below in the Decal column works if one option is selected, but I need it to work if Bone@row changes from Sternum to one of the other drop down options and also change if the…
-
Is there a formula that can pull data based on row # & column name?
For example, I know that on row 732 (specifically that row) in the Primary column I will need information to appear in another cell. Linking things manually is not an option given the volume of rows, so I need a formula. Any way this can be done? Also, the information in row 732 can be moved. So in the future the data…
-
Help with a SUMIFS formula
Kind Smartsheet Community - I need a hand with a formula. I'm trying to add an invoice amount in another sheet if the project name matches, if the approval column is "Approved" and if the Client Invoice # is blank or if the Date of Client invoice is in the past 5 days and I'm getting an error. I'm not sure if I can put an…
-
Populate cell with current date and time
Seems like a simple thing, but. . . . . . Within a row, if a specific checkbox is checked, I want to capture the current date/time in a cell, that will not change. In short, I want a column that looks like Created Date and Modified Date, but is a date/time that is triggered and populated based on a condition. I know I can…
-
Return a red icon when due date is at risk - almost there, but getting a "0" entry
Hi Folks - probably super easy, but am using a formula to return a red icon if % complete isn't 100% and if current date is 7 days out form target finish date. I am almost there, but I get a "0" when the criteria has been met (100% complete has been achieved). I would prefer a blank cell. Here is the formula I am using:…
-
Formula for ranking top 3 names/nominees in a text/number column
Hello! We have a nomination form with several text/number columns where people can add the name of the person or people they want to nominate. Most columns have 1 nominee for each row, but some have multiple nominees listed from a team. I would like to create a report or summary that ranks the top 3 names mentioned in each…
-
Formula to check box if child rows include due date within the quarter
I am trying to create a helper column on my sheet that checks a box if the child rows have a due date within the quarter. Our quarters are based on the fiscal year July 1 to June 30. So far I have the Q1 helper column with this formula which is getting and UNPARSEABLE error =IF(CHILDREN([Due Date]:[Due Date]) MONTH([Due…
-
Convert Multi-Select to Single Rows in Excel or Sheet
Hello, I have a need to use a Form to capture training completion, where the supervisor can select multiple values from an employee dropdown to select everyone who completed the training course. The attached image shows what that would look like within the sheet, where the employee name is multiselect. We then need to…
-
Priority Column Change based on Column Date
Hello, I am trying to use an IF formula to change a Priority Column based on a Service Start Date. If the Service Date is within 30 days, Priority column would change to High. If the Service Date is within 40 days, Priority column would be Medium. If the Service Date is over 50 days, Priority column would be Low. The…
-
Help on formula - Looking at two columns and depending on the responses in both
I have a sheet and want to create a formula that looks at the info in a column named "Bill Status" and column named "Our Stance". Based on the combinations of the responses in these columns I want and output of Win, Loss, Null. Column named Bill Status, possible options are: Active Dead Enacted Column named Our Stance,…
