Sameer Karkhanis
Sameer Karkhanis
Reactions
-
Re: Dates in a column
If you are not looking for a Column Formula then does the simple workaround of adding the formula =[Start Date]1 + 3, work for you? All you have to do is just drag the formula when you add new rows.1 · -
Re: COUNTIFS formula troubleshooting - multiple criteria and checkboxes
Try the below: (You had an extra parenthesis at the end in both the formula and also changed =1 to just 1) =COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Oth…1 · -
Re: Nested IF isn't working
The reason you are getting zeroes is coz you are trying to match all of those conditions in a single range {TA_Offer Decline data Range 1} and if will always return false/0 as you cannot have all val…1 · -
Re: How do I concatenate text in a different sheet and a changing number
@User251 Apologies that I missed the important part in my formula, I meant to say please use this so that you can reference the cell from other sheet as a range, ="Calendar Year " + VALUE({…1 · -
Re: How do I concatenate text in a different sheet and a changing number
Use this, ="Calendar Year " + {That single cell selected as sheet1 range} - 2)1 ·
