-
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
-
Work around for Year transitions when using the WEEKNUMBER formula
Currently, I have a project starting in September 2025 and ending in June 2026. How can I use the WEEKNUMBER formula to create September 29,2025 as week 1 and continue the numbering sequence through June 1, 2026. I also need the formula to flow well when date changes are made to the plan.
-
In Smartsheet, how do I lookup and return different values from sheet 1 to Sheet 2 in one cell?
Hello, In Smartsheet, if I want lookup and return different values from sheet 1 (Test-IMS) to Sheet 2 (Test 2-SOS) in one cell, what should I use? Note: The two values from Sheet 1 will be different. Let me know if you have questions or I need to clarify more. Thanks,
-
Returning multiple results for a cell with multiple values
I have two sheets: one is a form collection table and the other is a reference table. One of the fields (Code) entered in the form collection table will determine who is responsible for the request submitted. The Code cell can have multiple values (separated by a comma and space). It is possible to have multiple people…