-
How to Sum a total excluding numbers before a "0"?
Hello, I am looking to add a formula where we rollover the total points each quarter if the quarter is greater than zero for the prior quarter and add only the total points documented after there is a zero listed for a quarter. For instance if someone receives points in Quarter 1, no points in Quarter 2, but has points in…
-
Cell value for main or subworkflows.
I am trying to create a formula or workflow that changes a cell value to a value in another cell. I tried with workflow, but I can only assign a text or specific value from a drop down. But I want to assign a value from a specific cell. Formula would help, but this then needs to change depending if the cell is already…
-
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…
-
Need a solution for Parsing a value within a block of text
I have a schedule that automatically adds appointments from teams. Because of the way the data is retrieved it will pull all the meeting info into a block of text in the "Task" Column. I am not sure how this is done but I know its done using a bot in MS teams. Task column will always pull data that looks like this (without…
-
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…