-
Need help with a IF
Trying to create a formula where it would originate a % calculation based on a Yes or No from another column. New to this so not sure on how to proceed. This is what I have so far =IF([30C Low income or rural]@row = "Y" , (CAPEX@row * 0.30")]
-
Creating a test or assessment as a form
I am trying to create a test / exam / assessment in SS and create a formula to auto grade automatically. I created a column for the answer and a column to indicate if each column question is correct. The problem is when the user completes the test via the form, their response row falls below the answers, requiring me to…
-
How can I use a function to pull dates from Sheet A to Sheet B?
I have a master sheet of dates for multiple programs and projects. The layout of the sheet is: Program | Project | Start Date | End Date Each program is divided into hierarchies as such: Program A --Program A-1 ----Program A-1 | Project A | Start Date | End Date ----Program A-1 | Project B | Start Date | End Date…
-
Template/formula
Hi. I'm new to Smartsheet. Wondering if there was a template/formula that could assist with this problem? Say I have 10 building sites/projects and they are all staggered one week apart for commencement/completion over a 3 month period. I have a pipeline of projects that I can't start/bring online, until the next project…
-
How do I stop counting overdue days when the completion date is met using my formula below?
I have column headers (that reference my formula, conditional formatting, and workflows) for: assigned start date, assigned due date, projected duration, days remaining, overdue, start date, completed date, actual duration, and done. My formula to count days "overdue" is below: =IF(Done@row <> "Complete", IF(TODAY() -…
-
Trying to subtract a value on one sheet from another value on another sheet
Hi, I'm not great at formulas and I'm struggling with something that I feel should be rather simple. I want to compare some month on month data, the current months data is held in one sheet and the last months is held in another. So I used the formula below for the first cell (data range 1 being the specific cell in row 1…
-
Count if Sheet Summary Formula Help
Hello! I have a sheet summary for in-progress accounts that uses the Status as the CountIf variable. The problem is that the Status formula includes accounts that the Live Date is equal to or less than today. I need to omit the ones with Live Date equal to today for the sheet summary formula and am really stuck on how to…
-
How Do I make a Gantt Chart automatically show 100% for Complete when Status is marked as "Complete"
I would like to automatically update the %Complete in the Gantt chart to 100% if the Status is set to "Complete" in the dropdown list. I can't seem to figure this out. I have tried entering calculations / IF("Complete", 100%, if(Not Started, 0%)) etc. but because there's parents calculations by default, these formulas cant…
-
Getting Combined Names to dropdown in a form.
Hello, Our sheet has names captured in separate columns for first and last. I created an additional column that combines them with a formula to (First Last), however now I cannot use this in a drop down for a Form where the user can select their name from the list because the column has a formula in it. Is there a way…
-
Cross sheet formula question
I am using the following cross sheet formula - =COUNTIFS({Completed Contracts Range 1}, "Addendum", {Completed Contracts Range 2}, ">=01/01/23", {Completed Contracts Range 2}, "<=01/31/23") I keep getting a total of zero although there is more than 1. The dat formatted in the sheet is 01/01/23 and I am trying to calculate…