I am trying to create a sheet which identifies batches of 25 rows and creates a specific batch ID, before moving onto the next 25 rows. (Batch Column) I also need to formula to ignore rows with blanks…
Hi all, With the new update to Smartsheet forms, we are able to add conditional logic to designated fields within a form. However, I noticed that while you can set logic to only populate designated fi…
We have a large team all working within a workspace, and they already get a TON of email. Is there a way to set up a single daily notification for new items assigned to team members, without it being …
I am attempting to get the sum of two separate columns Number of Participants Reached (Adults) + Number of Participants Reached (Students) for FY 2021 only All 3 sets of numbers are in different colum…
I have an "At Risk" column and I want one row to flag if any in a set range of others are flagged. For example, on a project template, I have a "Planning Milestone"; I want the milestone to flag if an…
As a Smartsheet user, I want to be able to refer to a row when typing a comment so I can better give context and easily give URL's to navigate quickly to the other row. ---------------------- Use Case…
Hello! I am trying to find a way to show the development stage of a project so it can be rolled into a report. Basically if all of the tasks in a section are complete, then the development stage would…
When you create a grouping in a report, just above each section header is a little grey reminder of which column you are grouped by. This is repetitive and may not useful for people who view the repor…
I have timeline templates built out in a cascading fashion (with parent and children relationships) using "workday" formulas and a holiday list. I'd like to start the timeline off with an intake form.…