Formulas and Functions
Let the community help you with that tricky formula or function! See how others are utilizing the power of formulas and functions to save them time and create more powerful solutions with Smartsheet.
Discussion List
-
Summing fields in a web formIn Formulas and FunctionsI have built a purchase request form to replace a PDF and allow the users to enter details by department and upload attachments. One thing I would like to be able to do is to have the form sum up while being entered - item price + Tax + sh…
-
I need help for creating formula for automatic checkboxIn Formulas and FunctionsHi everyone I need to create formula which works as follow. If I put any date in column Completion date then checkbox Done will be in status checked automatically (Image)
-
Need help with a VLOOKUP and MATCH formulaIn Formulas and FunctionsHi there, I confess I get so lost when it comes to formulas. I've read through various community discussions and help pages, but for some reason I just cannot get the logic of creating a formula. In sheet 1 I have a column for "Freela…
-
Return Data based on two conditions being metIn Formulas and FunctionsHi, Please can you assist with a formula that checks data from two cells within a sheet that will then populate a matrix sheet. The data sheet is being populated via form currently. If Property Name is "Mykonos" and if Quarter 2…
-
Update Status and Progress of an activity based on Actual Start and End DateIn Formulas and FunctionsHi , I am relatively new to smart-sheet and would require assistance in setting up formulas for my POW Sheet .I would like to have my status column of an activity to be updated based on the actual start and End Date Start Date = Blank S…
-
Automated Workflow NotificationsIn Formulas and FunctionsHi everyone, I've created a sheet with multiple points to send a notification based on the date. Several columns are irrelevant to our work and are used simply to send a notification (i.e, if a checkbox is marked because month date and ye…
-
Referencing an entire column from another sheetIn Formulas and FunctionsHello, I am working on a cross-sheet formula. The ultimate goal is to write something that says this: If room column on [Sheet 2] contains "room name" AND (date on [Sheet 1] falls between Check in Date and Check Out Date on [She…
-
Sheet Summary when Request Owners VariesIn Formulas and FunctionsHello, I am trying to add a count of Request Owners to a dashboard. The Owner varies and I have not figured out a way to have new Owners appear. How do I include them on specific Owner Count on my dashboard. Is this possible? Thanks
-
Formula autofill to the next rows in a sheet when using hierarchiesIn Formulas and FunctionsHas anyone had any success with maneuvering around the fact that new parent rows created by a form and added to the bottom of a sheet will not inherit the formulas of the row above? Here's the note from the Smartsheet help: NOTE: Form sub…
-
How to use Form response to retrieve the right template?In Formulas and FunctionsI have 7 templates for client renewal. I want to create a workflow either with a form or formulas, the user will select the right template for the client renewal and automatically added to the Master Client Renewal Project Plan. Example 1…
