-
Conditional Formatting Disappears When I Begin to Work in a Sheet
When I am enter into a sheet with conditional formatting I can see it applied. But if I search for something, or begin to scroll, or click into a cell the formatting starts to disappear until it is all white again. When checked the formatting rules are still present. I checked and didnt see another issue like this…
-
Need local time based on City & State
I am building a solution whereby I need the local time based on City and State. This is a lookup sheet whereby a store # is input and formulas return address, phone # and contact. I need to include the local time as well. For instance if store is located in Dallas TX then I need local time in Dallas TX. However, if store…
-
Add a "Today" button in Calendar view
I would love to see an option to be able to quickly navigate to the current date in the calendar view. Every other platform with a calendar I've used (Outlook, iOS, Airtable, etc.) has a "Today" button that will immediately navigate you to the current date. I already find that Smartsheet calendar view does not always open…
-
Merged: No longer able to add attachment to sheets for licensed users
This discussion has been merged.
-
Task Status Update based on Previous Step Completion
I've been asked to lock the "Status" column and only allow changes to the "% Complete" field by the assigned task owners. This admittedly will limit the use of all the status' as I'm trying to develop a strategy to simply change my approach and limit the functionality options. My Status column should ideally include the…
-
Quoting tool
I am trying to create a quoting tool for our fencing company. I need to add # of products + pricing and have a data field on the quoting form that calculates the total. Example: 50 Ft of fence at $10 = $500. Can i get that to calculate on the form? Trying to create a final quoting page to give customer. how do i do that?
-
=LARGE Formula Question
Alright Smartsheet gurus, I need a hand! I am familiar with the LARGE function and how to use it to identify the highest numerical values in a column. However, what I am trying to accomplish is to feed that data into a dashboard that identifies those values' corresponding categories. For example: Location1 100 Location 2…
-
Ideas on how to manage high volume, bundled update requests?
Hey Folks, I manage a later sheet where we will be rolling out regular Update Requests. These requests are grouped by Lead by Project. This means that when a request is triggered, some individuals may have 10+ project rows requesting an update. The issue: When these are triggered at the same time, they become bundled into…
-
Date and Time issue - Calendly>Zapier>Smartsheet
can'tHi I have people booking times with my company via calendly>zapier>smartsheet. However, the date and time arriving in the smartsheet cells is appearing as eg 2025-11-25T05:00:00.000000Z. I cant get this to change without it becoming UNPARSABLE. I have tried some standard formulas that AI is suggesting to no avail. Can…
-
From End Date Calculate Start Date
a date function that start with the "due" date(end date) and total hours to calculate the start date