-
HELP!!! I am working on a nested IF formula that just doesn't work, any help is appreciated.
I am trying to calculate the total revenue per month as well as the Margin % per month from our Sales Pipeline. Some of the projects run into the following month so we need to see what the revenue and margin are for each part of that time frame. I was able to get the formula to work for the margin % but only for one cell…
-
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.