-
Establishing a Cadence of Update Requests
Our Program Developers are asked to provide an update on the progress of programs they are developing every 2 weeks. In my Sheet, a row for each program was copied from another Sheet once a proposal moved to development. So, I have a [Created Date} to use as the start of the first stage of development. I also have a…
-
Scheduling Emails
I am running automations to send emails when text or a checkbox is active in a cell sending row information to different people, there are no attachments on these emails. I would like to know if I can schedule the emails that are triggered for once or twice a day. This will allow for fewer emails when a lot of rows are…
-
Auto-Assign Task in Board View Based on Filtered Individual
Hi everyone, I’m looking for a way to automatically assign tasks to an individual when a new task is added in Board View and a filter is already set for that person. For example: • I have my Board View grouped by Assigned To. • If I filter the board to only show tasks assigned to me, and then I add a new task, I’d like…
-
#REF and other errors
I made this sheet with various VLookups and everything worked for about 10 minutes then all the items became errors. This is an example of one of the formulas giving a #REF error =COUNTIF({SDI Termination_Details 2025 Range 1}, "2007 - Outlet 1") + COUNTIF({SDI Termination_Details 2025 Range 1}, "2000 - F&B Dept.") +…
-
Help with COUNTIFS Formula: Unparseable Error When Counting Completed Rows After a Date
This discussion was created from comments split from: COUNTIFS between dates & criteria..
-
In work Formula
Hello, I'm trying to figure our this formula and need some help. I'm not sure if someone on this discussion board would be willing to have a meeting but that would be even better to help me. I want the formula to be; If this other referenced sheet has this number, in this column and this cell of this row in this column has…
-
Smartsheets new User Subscription Model True Up Page is horrible
If you are going through the true up you are going to want to read this experience. Lets face it, no one is really happy about the new Smartsheet licensing model. It's costing all of us more money and that sucks. It took some time but I eventually got past it, we went through and figured out who would need a license when…
-
Inserting/Creating Rows Automatically
Is there any way to automatically create/insert a row into a sheet based on a trigger from within that sheet, like a status being set to a specific value? Essentially, copy a row of a sheet and paste it as a new row with some of the values changed?
-
Template Libraries
It would be really useful if both individuals as well as admins / system admins could create template libraries. Individuals could create and use their own templates across multiple workspaces. For companies, it would be very useful to have branded templates available that could be shared to everyone who is on the company…
-
Nominate Peak Humans & get a badge!
Hi Smartsheet Community, We loved learning about what operating at your peak looks like for you, and now, we want to give you the opportunity to recognize and celebrate others, and earn cool badges as you do it 😉 The Operate at Peak Human campaign is a celebration of humanity. Recognize someone who does a great job in any…
