-
Monster IF formula for date timeline
Link to the sheet: https://app.smartsheet.com/sheets/2VgXpPQp84VmwJhcMhmG5Mp993jXFqgfMJ9cqGw1 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…
-
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…
-
Merged: Formulas in Forms
This discussion has been merged.
-
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…
-
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,…
-
INDEX/COLLECT Formula Help
Hello All, I am hoping this community can help me figure a particular scenario out: I have 2 Sheets: Sheet A, Sheet B I want to look at Sheet B: Find a unique identifier in Column A (this is also the same unique identifier in Sheet A, Column A), then look at column C to see if it's blank. If it's not blank, I want a…
-
Adding Checkbox Not Checked to Working Formula
I have a working formula that I'd like to add a condition to, if possible. Here is the working formula: =IF(ISERROR(MEDIAN(COLLECT({Resi - Pricing & Tools Duration}, {Resi - Enter Stage 7 Date}, AND(@cell >= DATE(2023, 7, 1), @cell <= DATE(2023, 7, 31))))), "", MEDIAN(COLLECT({Resi - Pricing & Tools Duration}, {Resi -…
-
JOIN COLLECT excluding value on current row.
Hello all, I have a working formula but I want to not JOIN COLLECT the value on the current row (@cell) e.g. in the clashes column, row 3 would just return 'Sub Task 1' and row 4 and 5 would be blank My formula: =JOIN(COLLECT([Project Name]:[Project Name], [Person 1]:[Person 1], [Person 1]@row, Start:Start, Start@row >=…