functionality
Discussion List
-
Auto SortIn Using SmartsheetHello, Is there any way to create automation that will automatically sort a sheet when a cell is updated or changed? Thank you, Sean
-
Locating the parent of a parentIn Formulas and FunctionsI am trying to take the value from the primary column of a level 0 parent and insert it into another column in a level 2 child. =PARENT([Task Name]@row) works fine when there is only level 0 and level 1. Something like parent of a parent i…
-
Row ID (ignoring blank cells)In Formulas and FunctionsI 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 entries. (Row ID) I hope somebody is…
-
Conditional Logic for Header fields in FormsIn Formulas and FunctionsHi 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 fields when a certain option is selected,…Answered - Pending Review 447 views 10 comments 4 points Most recent by Genevieve P. Formulas and Functions
-
Is there a way to set up Cumulative Roll Up Notification EmailsIn Formulas and FunctionsWe 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 an email for each sheet? We have abou…Answered - Pending Review 45 views 8 comments 0 points Most recent by specoop Formulas and Functions
-
SUMIFS FormulaIn Formulas and FunctionsI 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 columns I can get the total sum of the two …
-
Flag is others are flaggedIn Formulas and FunctionsI 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 any rows within the …
-
Is there a way to refer to another "row" within comments/conversations? Refer to unique rows via URLIn Using SmartsheetAs 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: I leave a comment on Row 1. Row 1 is…
-
Project Phases of DevelopmentIn Using SmartsheetHello! 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 be the name of the next header task. F…
-
Lock or Store Date/Value Solution without using ZapierIn Best PracticeHi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'd trigger the copy-row to another shee…
