-
CONCATENATE Formula Help
First, I had the following formula to return the number of tasks marked done over the total number of tasks (i.e., 10 / 50 complete) , then realized Smartsheet did not support the CONCATENATE function. =CONCATENATE(COUNTA($[Done]$2:$[Done]$51) "/" COUNTA($[Task Name]$2:$[Task Name]$51)," completed ") So, then, I tried the…
-
Formulas
Hi, I have started an Inventory Control sheet for my husbands business. He doesn't keep a lot of stock, but needs to know when things go in or out for ordering. I have set up the coloured balls to automatically indicate when stock is needed to be ordered, but would like to be able to automatically keep a running stock…
-
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…
