-
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…
-
Blocked Formula
I am using a sheet to track skills of new paramedics. I created a formula to generate a total for a specific paramedic. I copy and pasted the formula to the next row for another paramedic. I changed the name of the medic and it I get Circular Reference in the original cell and Blocked in the new cell. Does anyone have an…
-
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…
-
Assign in rotation
I have a sheet, and need to add an "assign to column", and would like to auto assign each line to one of four people in a rotation. So, submission one goes to the first name, submission 2 goes to the second, submission 3 goes to the third, submission 4 goes to the fourth, and then the cycle repeats with submission 5 going…
-
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…
-
How to disable popups that obscure my formula?
I'm editing formulas in a Sheet Summary. However, I'm prevented from seeing the formula by an annoying "helpful" popup that obscures my view. I can't figure out how to get rid of the popup. Does anyone know?
-
Help with Sheet Summary formula
Hi there - I'm wondering if it is possible to join text via a formula in the sheet summary panel if certain criteria are met. For example, if the year is 2025 and the End Date is in the future, and Parent = "Real Estate Budget Items", I'd like to list both the Budget amount ant the End Date separated by a comma. In this…
-
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
-
Post Dashboard Demo Questions
I always get the same question after I do a dashboard demonstration. 😂 "How do I export this to Excel?" What are some questions you get after demonstrating a Smartsheet dashboard's capabilities?