-
Auto filling a Formula
I am using a formula to do a COUNTIFS based on Dates, a drop down YES/NO column and a name. I am wondering if it possible to auto fill the name portion of the formula from another cell. The formula looks like this: =COUNTIFS($Date:$Date, <=DATE(2017, 6, 30), $Completed:$Completed, ="Yes", $[Assigned to: Editor]:$[Assigned…
-
If statement based on date
I am trying to create a formula within my "Academic Year" field so that if the "Date" is more than August 25, 2019, the Academic Year field contents will be "2019-20" -- otherwise, the field contents will be "2018-19". =IF([Date]1 > (2019, 8, 25), "2019-20", "2018-19" I am using the date format (2019, 8, 25) based on what…
-
Limit Dropdowns Based on Previous Input
Is there a way to create or limit a dropdown based on input from previous field in Web Forms? So if the user chooses makes a selection in Dropdown #1, I want to tailor the options in Dropdown #2. I I know you can do this in Excel, but now sure here. Newbie and looked through community and help --any advice would be…
-
Problem adding countifs
I'm trying to count projects that have either a four or five priority and this formula works: =SUM(COUNTIF({PLT Project Roadmap Range 17}, "Four"), COUNTIF({PLT Project Roadmap Range 17}, "Five")) I want to count projects with either a four or five priority that start either today or in the past and this formula doesn't…
-
Project Cost Calculator Smartsheet
I am looking for a template in smartsheet that I can use to build costs for projects and training courses we conduct. I noticed that on the smartsheet website advertisement it says that smartsheet has the solution. My goal is to program some of our costs to do business with certain rates and then send forms to the Program…
-
Special IF Formula for Stars
I have two columns: * [Infrastructure Project] is a checkbox * [Product Priority] is stars (0 - 5) If [Infrastructure Project]@row is checked, I would like [Product Priority]@row to be 5 stars. If it's not checked, I would like manual entry for the stars. This would be simple if [Product Priority] were empty, but I already…
-
Linked Cells that are not read-only
We keep our master calendar/schedule in Smartsheet. Every year, we create a new copy of the sheet and insert dates for the new year, but the majority of the other content stays the same. Is there a way to do a cell linkage where the linked cell in the destination sheet IS editable? For example, for each row on the…
-
Complex Formula for RYG Automation
I automated the RYG circles according to several columns of a Smartsheet grid for project management purposes. The logic is below: IF [Proposed Product Launch Date] <TODAY, "Gray" IF [Proposed Product Launch Date] >=TODAY AND [Deviation from Proposed Launch Date] <100, "Green" IF [Proposed Product Launch Date]…
-
Reference a Report
I am using a form to track time spent on projects. Right now, they select the project from a dropdown list that I manually created and then they type in the task and the hours worked. Ideally, I would like for the Task Name to populate according to those available based on the Project selected. For example, if the user…
-
Limit rows in a sheet
Is there a way to limit the number of rows created by a form? I want to use a form for people to register for a training event, but am limiting the number of attendees to 50. Is there a way to automatically deactivate the form when 50 rows exist in the sheet?