-
IF(AND formula
Hi, I am using this formula =IF([Warranty Status]@row = "Warranty Expired", IF(AND([Asset Status]@row = "In-Stock), "Out Of Warranty","")) Its says the formula is unparseable. I can't figure out the issue with the formula. Help is appreciated.
-
Burndown Chart
Hi Everyone, I have a question about how to drive a burndown report in a Project summary: I've built a burndown sheet that contains the Application Name, Baseline Finish, and Actual Finish dates. (Those three columns are linked to other project schedule sheets.) I've also built a Cutover Date column that lists every…
-
Identifying a risk in my project plan.
I have a risk sheet with a system generated id column (ACT-0001); etc. In the risk sheet I have a helper column to identify if the risk is linked to a task in my project plan sheet. In my project plan sheet, I have a column called RiskID that contains a string of risks (ACT-001; ACT-0002; etc.) linked to a task. The risks…
-
help with auto numbering my projects that have children and grandchildren
I want to assign project numbers to the main project, and then append that project number with .(letter) for the Subprojects, with Tasks still being assigned to the main project number, with the letter of the Subproject, and adding more hierarchy, such as I'd like the task to read 40.c.1, or something similar that…
-
Sheet folder Template
1.We have 5 sheets which are interconnected through formulas the whole folder or workspace needs to be saved as new template Note: The formulas should not be removed Is there any way for this? How to create a template set?? Thanks, Keerthana
-
How to dynamically populate a dropdown box
Hello, I'm new to all of this. I am wanting to have a staff database that is connected to a purchase order database. When a user fills out a form for the purchase order database I want them to be able to select the staff member from a dropdown box that is pulling unique data from the staff database. I cant figure out how…
-
index collect
HI All, I have a formula that i have got working - only issue i have is I have run out of cross reference "space" and cannot add my last spring to complete my function is there anther way to do this Source sheet OR date UP date Site Target sheet Required date Updated Date Site i need to return source sheet UP date, when OR…
-
How do I dynamically update a dropdown list?
I want to create a multi-select dropdown list with all future dates and this will be sent out in a form. Currently, smartsheet only offers a date selector with one max date. I was wondering, is there a way to upload values into a dropdown through an API? Otherwise, can I upload values into a dropdown from another sheet?…
-
Formula as alternative to Dynamic dropdown menus?
Hello, I have seen in previous discussions that dynamic dropdown menus are not available without a third party app or Data Shuffle. Neither of those are options right now, so I am trying to do the next best thing. My situation is this: I have two sheets , the first sheet is a a project specific sheet that has the task…
-
Dynamic Dropdown Lists Driven by Formulas
Hi all, Is it possible to dynamically populate dropdown lists in Smartsheet based on the contents of another column or sheet (like dependent dropdowns in Excel)? If not natively, are there creative formula-based or automation workarounds users have found effective for keeping list options up to date as data changes?…