-
CountIF check boxes error
Using the formula =COUNTIF(CHILDREN(), 1) in my check box column and it throws the error #1 or 0 expected. There's an article explaining to do it this way (unless I am misunderstanding) https://www.smartsheet.com/blog/support-tip-checkbox-formula What should my formula be instead?
-
THANKS to all the Formula Gurus!!!
Dear Fellow community, While I know Excel rather well..VLOOKUP, PIVOT TABLES, etc, the LOGIC and IF formulas sometimes cause me trouble. Anybody with me.?? OK.. so I'm doing what my daugther calls a "humble brag" cause I'm tooting my horn, but giving credit to others..... Today (with lots of help and patience), I was able…
-
Help with Sites and Sheets
I'm struggling to create two things in my Smartsheet. I'd like to have a countdown in the completation date from "today" until our project's expected final day. And capturing the %done of the project in smartsheet, maybe I'm doing something wrong but the =AVG() is not working for me. I'd like the program health to indicate…
-
Date conversion
I feel like I'm off my game today. I hope I'm wrong here but this is what I have. Sheet 1 has a Date column For other design issues, that date is linked to a Text/Number formula on Sheet 2. In sheet 2, I want to take the date and compare it to a real date in the sheet. Addiing =[Text Column]23 to a date field results in a…
-
How to count number of flags in column?
What formula would I use to count the number of flags that are up in a column?
-
Add requirement to formula is a cell is blank versus not blank
Here is what I am trying to do for our contracts: Cells I'm working with (for the formula) • Contract Start {Date} • Contract End {Date} • Remaining Days {Number} // formula =[Contract End]1 - TODAY() • Contract Status {Dropdown - see below} // formula =IF([Remaining Days]1 < 0, "Expired Contract", IF([Remaining Days]1 >…
-
Variance confusion
I have a [Start Date] and [Due Date] with Dependencies enabled. I know the dates used for the scheduling will have a time component. Other date columns do not.. I copy the data (Cntrl+C, Cntrl+V) to Baseline columns. Date component matches. I then create Variance columns where Variance_Start = [Start Date] - [Baseline…
-
Auto-increment a new form entry if it matches an existing name
My team is using Smartsheet to track interactions with our customers on Facebook. To keep a record of the interactions, we're using a form to populate a sheet with the data (time, date, sentiment, that sort of thing). I'd like to find a way to automate one of the questions in the form - how many times we've interacted with…
-
Automating text based on information in other column
Is there a way to format something like this: If column A is True than column B says blank? The reason I ask is that I have a report with site in one column and the next column should have id. It would be much easier for the id to popluate based on the site in the first column.
-
Formula to calculate the next Friday after today
I have the formula below in Excel that calculates the next friday from today's date; so that any time the sheet is opened before a friday it will automatically insert the date for the coming friday, and when that date has passed and the sheet is re opened it will automatically insert the next fridays date in the week…
