-
Auto-fill formulas and corrupt references
Hello, I'm currently in the process of setting up a rather formula-heavy project sheet, linking project names, project numbers and multiple assignees to all the different tasks within the project. In order to circumvent the limitation of one assignee per task on my sheets, I've created additional (non-Contact list) columns…
-
COUNTIFS
I need to count the number of times the "Status" column = "Assigned to SCJ" and the number of times a date appears in "NDA Signed" column in the same row. Both criteria need to be met. The "Status column is a drop down list. The "NDA Signed" column is a date. In the parent row, I added this calculation but it is not…
-
Calculating a Due Date
Frequently in legal transactions a transaction closing date may depend on the outcome of a couple or more previouls tasks. It will be the later of two or more previous tasks. Each task's completion date plus a different number of days depending on the task. The answer is the latest plus another specified number of days.…
-
Multiple Duration columns (or a way to calculate number of day between two date columns)
I'm trying to setup a sheet for tracking actual work dates vs target dates Construction Document set timing. In each deliverable/row I'd like to list the following dates: • Target Date * • Act Start * • Act Finish * • Approval Date I have my the project settings turned on so that "Act Start" and "Act Finish" create teh…
-
Date Counter for Weekly Ontime Rate
Hi there! I need some help coming up with two formulas that will count how many times in the week we hit our projected due date and how many times we are early. I already have a hidden column that looks at the date and calculates the week of the year. I need the fomulas to read something like: count if 'date completed' is…
-
Formula that only counts business days
Hello, I'm trying to write a formula for a date that will say something like "due in 18 business days". So basically " =[column name] + 18" but exclude weedend days. Is that possible? Thanks so much!
-
IF statement with two criteria; not functioning
Hey all, Trying to get a “No” to appear if the checkboxes in each column haven’t been checked off by their due date. Currently, it says no regardless of the date and it only seems to switch to "Yes" if the Client Launched column is checked off. The two criteria are that the box is not checked off and the Launch Date is…
-
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…
