-
Formula to add 1
I am trying to figure out a formula that will add 1 to the Parent [DMR #] The below will Place a "1" at the end but I need to add count by one Like this DMR5575-1 DMR5575-2 DMR5575-3 =IF(Level1 = 0, [DMR #]1, PARENT([DMR #]1) + "-" + 1)
-
Is there a way to pull only the children into the report?
I am trying to have a report that shows only the lowest indented children in it. I am working on a sheet that has 4 level of indents. Workstream (indent 0), Project (indent 1), Milestone (indent 2) and Activities (indent 3). The report needs to include activities only and not any of its parents. Please let me know if there…
-
Formula autofill to the next rows in a sheet when using hierarchies
Has anyone had any success with maneuvering around the fact that new parent rows created by a form and added to the bottom of a sheet will not inherit the formulas of the row above? Here's the note from the Smartsheet help: NOTE: Form submissions will always be fully outdented. If the last row in the sheet is indented in…
-
Approval Workflow Not Working
I have an approval workflow that is currently in use. I referenced and copied the workflow exactly but it is not working the same way. I have it set up so that when a cost is entered in, it sends an approval request to a set group of people dependent on the plant that is selected as well as the amount requested. As I said,…
-
Pivot: Add Row Links from source sheet
We're starting to dive in a make use of the Pivot app, and it is extremely powerful, however we are finding that it would be extremely useful for users to be able to affect the base data from the Pivot sheet more easily. One idea I have would be if there was a link in the Pivot sheet for each row directly to that row in…
-
How to alert person in next row
I have an onboarding worksheet where each row is assigned to someone and I would like for the person in the next row to be alerted once the row above theirs has a completion date. Can this be done in smartsheets?
-
How do I count how many cells are last month but not considered expired?
I am working on a sheet for currency of qualifications for our employees. I have the equations that will tell me how many employees are a month before they are due, how many are due this month, and how many are in the past but now I have to find and equation that will let me count how many qualification are only one month…
-
Simplest way to update staff on onboarding tasks
My organization (a small physicians office) is creating a new onboarding check list via smartsheet. We want to update the staff on certain tasks they need to complete for new staff members going through the process. I've considered a few options but wanted to ask if anyone had an idea on how to do this. Thanks
-
Check Box Question
Can you make a requirement to fill out specific boxes before you are able to check the checkbox? So basically you can't check the box unless Column/Row A1 -- B19 -- and M24?
-
Reports using HOURS past Creation Date/Time Criteria
Hello friends, I need to be able to create a REPORT where the only rows that appear are those that are equal to or greater than 3 hours past the Creation Date/Time. Is this possible?
