-
Count and Lookup - based
Experts, I need to count the values of each column excluding Today Value. Rest of the Yesterday and Blank values of respective columns like #New Hires, and drop the values in the 2 Yesterday Metrics. It is pretty easy to do a vlookup for Today, but if I need to cumulate the Yesterday and Previous day values. How do i do…
-
Count if Formula to retrieve multiple criteria
Hello Experts, I am looking for a formula to count all of the New Hires from Yesterday/Today column using Previous Days and Yesterday values.
-
Batch Sheet Creation from Template
Problem: Current Limitations Manual Repetition: Provisioning a large project (e.g., 50+ distinct team sheets) currently requires manually executing the "Use Template" or "Duplicate Sheet" workflow 50 separate times. Time-Consuming Setup: There is no native bulk-action to instantiate multiple files at once, creating a…
-
Automation Message to specific contact with only their relavant entries
I have a grid with date from multiple users. I want to be able to send out a message each month to the user showing only the entries they provided. For example, Leo would get one message showing his client, date, program name and #_participants. While Sandy would get one message with the two different clients and the…
-
How can I get this formula to work
Hi, I still have a lot to learn in Smartsheet, but I have been using co-pilot to assist. However, I need help with this formula that I cannot get to work. My goal is to strip the site names off any special characters expect for the first four letters# and "offnet. I'll appreciate the any assistance that can be provided to…
-
Viewing Last Updated in Sheet
Hello! Is there a way for me to track user interactions in sheets? I have found how to see last updated by. But am I able to get more specific with this? See when a sheet was last viewed? And when updated am I able to track what was changed at a cell level? Thanks!
-
Save & Resume Update Requests + Automation for Unchanged Rows
I’m currently building a Client Health Report where CSMs provide monthly updates across their clients. Challenge #1: No “Save & Resume” for Update Requests Many CSMs manage a large number of accounts and don’t always have time to complete an update request in one sitting. Right now, they must submit everything at once,…
-
Need formula help
I'm trying to match info in another sheet and return a date column to the first sheet. I've tried a few things but keep getting errors. In Sheet A each row is a job number. I want to fill in the job completion date from Sheet B. It has many job number rows with different job types. The Job type column is Parent/Child. I'm…
-
Incurred hours not showing for future dates within the same month
Hi everyone, We are using Smartsheet Resource Management for capacity planning, operational follow‑up, and monthly financial reporting, and we have a recurring challenge related to how Incurred Hours are handled in reports. We understand that incurred hours are date‑driven (past vs. future), and that this behavior is…
-
Lookup Value and Count based on the input criteria
Hello Team, I am trying to bring a formula to look up a value and bring the corresponding counts. The input sheet will look for the "Date of" column and dynamically generate the Yesterday or Today value based on the formual i have written for "Yesterday/Today" column. There is a person going to enter #New Hires, #Leavers,…