-
Moved Project into another folder and it messed up formulas within project meta sheet
Good Morning, I created additional folders to organize project folders but it seemed to mess up formulas within my project meta sheet and gave the following two error codes in some sections; #BLOCKED and #INVALID REF. When I clicked into what sheet is being used as a reference it did not show an error within that sheet. I…
-
Formula Help: How to exclude past dates with MIN formula?
I am not good with formulas and haven't been able to figure this one out with usual troubleshooting... I am using the following formula to return the next upcoming Review Date (screenshots of use below). =MIN([Next Review Date]27:[Next Review Date]30) But I want to make it so that it doesn't include dates that are in the…
-
Mandatory Comment on Approval Form.
Hello, How can we make the comment section in the Approval Form mandatory? like it is mandatory no matter what.
-
Need help with a formula to sum all numbers in a column that have the same date?
Hi there -- I'm working on a project where I need to track the total number of hours a person worked each day. A person may have three rows (log entries) with the same date, so I'd like the formula to count the hours column for each row that has the same date. In the example above, the Total column would show the total…
-
Sheet - set a cell default
The ability to have a default value in a cell for a new row. Currently can only do this when the new row is being entered with a form
-
Helper sheet no longer populating
We have a helper sheet that absorbs certain orders, entered by a form, to fill another sheet. It is no longer populating. The only thing I know has changed is that some column names on the main sheet had been altered in order to set up an automation for a totally different sheet. Nothing else appears to have changed. Would…
-
Help with Index Formula
Hello! I am creating one master sheet for a variety of portfolio metrics (we currently don't have control center - working on that!) and am having trouble figuring out the best formula to populate the data I need for this one item. I want to calculate how many strategic projects vs. KTLO projects a team has for the…
-
How can I link predecessors from one sheet to another?
A task in sheet A is required to be completed before a task in sheet B can be worked. Is there a good way to do this? Note: I also have a master sheet that is fed from the values in sheet A and B combined. I want to be sure the integrity of that link carries over into our master sheet. Thanks!
-
Automate sheet creation
Can I use automation to trigger the creation of a new sheet? Here's the situation. I have a form that adds a new row to a sheet. I would like to evaluate the primary key's value against what already exists in sheet and do one of two things: if the value already exists add the row to the existing sheet for that primary…
-
Auto-check checkbox upon import?
Hi, I have a Smartsheet sheet that is fed by Formstack submissions. I added a checkbox to a column - how do I auto-check that checkbox on all imported rows? Some background: this sheet feeds into a report along with several other sheets. All the rows on this sheet are from one district, and I want to note on the report…