- Notification emails with new Proofing feature
My organization plans to start using the new Proofing feature, and today we did some initial testing to see how it works. We noticed that the person who requested a proof review didn't get ANY notification emails when new comments, approvals, or rejections were added to a proof. We tried to set up notifications using…
- Modifying a date based on 2 variables
Hello Everyone! I would like to create a formula that says If the value in the "Variable" column is "HIGH" AND the date in "Column 1" has a year less than today's year, return that date with TODAY"S year. Otherwise return that date unchanged. In other words, dates in the previous years are brought to this year, dates in…
- Can a range be specified with a beginning and no end?
I'd like to create summary rows at the top of my sheet, but specifying the entire column as a range in the formula is causing #circular reference and #block errors. Is there a way to specify a range from row 25 to infinity? I'd like additional rows to automatically be included in my summary calculations. The formulas I'm…
- Tagged Comment Fields
将两个建议,一个是abilit吗y to add tags/categories to comments. Second would be ability to configure the tag(s) to be shown in the latest comments column that was recently added We use multiple columns to add notes and comments for a mission from particular program areas such as volunteers, logistics, safety…
- Sorted column keeps resetting
We're using forms to gather requests into a smartsheet and the default sort should show the newest request first. There is a Created (Date) System column in order to sort by newest received but the sort continues to glitch each time the sheet is closed and it defaults to sort oldest to newest. This is creating some…
- Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
- Health formula help
Hi - I'm sure lots of folks ask for assistance with similar things, so I apologize if this has already been asked/answered; I just haven't found anything to match my particular situation. I am trying to create an IF statement that will take into account multiple columns and conditions for a grant funding project management…
- therapy caseload/client data tracking... anyone have success with smartsheet?
Hi all, I'm an Occupational therapist for kids with autism. After the pandemic rendered our therapy office paper data filing system obsolete(I couldn't access it from home), I determined to make the move to digital client records Smart sheet seemed like a user friendly option over excel I'm looking for a basic set up that…
- Index Collect that excludes previous values in returning sheet
Hello- I am attempting to create an architecture where employees are auto-populated based on role. I have a sheet with the entire orgs employee list that contains names, employee numbers, and titles The working sheet is attempting to pull in all people of each job title. Each row is a job title (same title with multiple…
- [RECAP] Breaking Ice and Breaking Barriers with Special Olympics Washington ⛸
Earlier this month, we welcomed Special Olympics Washington athletes to Seattle Kraken Community Iceplex for the second annual Breaking Ice and Breaking Barriers event! It was an amazing night, celebrating with our partners our shared goal of creating an inclusive community, changing how the world works (and plays). Thank…