-
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…
-
Building a quiz with Smartsheet
Hi, I'm building a quiz of 100 questions for 20 students and I want 25 questions out of the 100 to be randomly selected for each student. Is there a way I can go about the random selection? Thank you.
-
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…
-
How do I count planned completed action items by month?
Hello! I have an End Date column and a Status column. I would like to build a formula that counts if Status is "Complete" and End Date is a designated month and year. I would like that formula to generate a 0 if none can be counted. End Date column type is Date, so dates appear as DAY/MONTH/YEAR. Status column type is…