-
Referencing a sheet that has non-working days
Hello. I need help please. I am working on a Smarthsheet schedule where I need to define the calendar (ie exclude public holidays and our annual construction builders break) without enabling dependencies because that messed up my sheet previously. I have a separate sheet that has a list of non working days. My formula is a…
-
PTO/Absence tracker - how to deal with recurring events
I am creating a PTO/Absence tracker for our service technicians team. I have 2 separate input forms. - one to record/request PTO filled out by the service technicians themselves - another for Supervisors to book a service technician to a client site for a dedicated amount of time, - i.e., every MON for the next 3 weeks -…
-
MS Power Automate Get Last Row of Data
The desired flow is: Smartsheet form is completed which includes three key pieces of info: Name, Email, Waiver This creates a new row in a Smartsheet A Power Automate flow is triggered where it checks specifically the Waiver (which is a dropdown either needed or not needed). If needed, the flow continues. I built an…
-
Formula for Month in words
Hi everyone seeking for a help please I'm making a helper column formula for month I want the result as Month - day- Year (October 28, 2025) but it seems my formula doesn't work is there any way to have this formula or result as (October 28, 2025) =IF(ISDATE([Refund Deadline]@row ), MONTHNAME(MONTH([Refund Deadline]@row ))…
-
What happened to Default View?
Hello, I'm no longer seeing the default view option in my sheets. For example, we have a shared PMO Calendar that was previously set to "Calendar View." When I accessed it recently, I noticed that the default filter option is no longer available. Has this functionality been removed? We recently moved to Enterprise, but I'm…
-
How to Sum Across Multiple Sheets?
Hi, I have six sheets with an identical setup. I want to be able to summarize how much Effort each person has been assigned for all the sheets. For example, Bugs Bunny may have 12 hours assigned in Sheet 1, 4 hours in Sheet 3, and 24 in Sheet 5 for a grand total of 40. I want to be able to summarize total Effort for each…
-
Countif with contains
I want to count the number of times the word Booth is contained within a row for each of my vendors on my sheet. There are other words in the row such as cancel or no show. I have tried =COUNTIF([May 11]@row :[Oct 26]@row ), CONTAINS("Booth", @cell) and =COUNTIF([May 11]@row :[Oct 26]@row ), CONTAINS("Booth", @row) and…
-
Locked column changing to date column type
Looking for some help, I have a sheet where I have locked a column to a contact list type. When I log back in to Smartsheet at a later time, the column type is still locked, however it defaults to a date type. This is happening on another column as well which is not locked due to requesting updates from those assigned in…
-
Copy of Submission Not Showing All Columns
Does Smartsheet show all columns in the "send me a copy of my response" email from submitting a form? We used to show a critical piece of data in that our submitters would use for their records but now that column no longer appears in that email. The column used to display in the email, and has not been adjusted since the…
-
Am I doing it wrong? Salesforce connector, Mesh, control center, Data shuttle ugh and now RM
:) Replacing a JIRA system that was not really used well with Smart sheet and Sales force in a united front to try and perform work flow, report out, and track time, then export for billing back to Salesforce. High level, we have a pre sales sheet that captures input from Salesforce on win, loss, and or type of project.…