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
-
RAG status formula using TODAY and end dateIn Formulas and FunctionsHey smartsheet community, any help fixing this RAG status formula? I am trying to automatically show RYGG balls dependant on the end date and today's date. With the exception of cancelled and complete tasks; any task with the end date TOD…
-
How to troubleshoot the error in a formula? I am receiving #UNPARSEABLE errorIn Formulas and FunctionsI am using a simple if statement but receiving a #UNPARSEABLE error for the formula: =IF(([Proposed 2020 Base Salary]@row-[2019 Base Salary]@row)/[2019 Base Salary]@row=-100%,"",([Proposed 2020 Base Salary]@row-[2019 Base Salary]…
-
To Pull a recent status from another sheetIn Formulas and FunctionsHi Hope you are doing well. I have one sheet "Sheet 1", in which we have 2 fields that will be filled through the form. One for scanning the barcode of the Product and 1 for updating the status of the Product Process for ex- Raw…
-
Form Submission creating new row - cant do notificationIn Formulas and FunctionsI have a sheet which has 10 columns. It is meant to collect data and trigger notifications. The first 4 columns, I have created a form to collect data from user. The 6 other columns are for tracking on status and assigned to user column. T…
-
Is there a formula for what I have described below?In Formulas and FunctionsI want to add or subtract a row in a separate column when another column’s row has data. Basically I have a master column that houses certain numbers one being 46. I have other columns that are name Date item added and Data item removed (D…
-
Automation in WorkflowsIn Formulas and FunctionsHow can I Request an update to separate person as per the specific data in the form. For example, we have 4 department named Dept 1, Dept 2, Dept 3, Dept 4 and we have 4 separate managers for each department M1, M2, M3, M4 respectively. No…
-
Using forms to update a recordIn Formulas and FunctionsI've perused the Smartsheet community posts for the answer to this question and get varying results. Objective: Use a Smartsheet Form to update a row (a record) of data. Background: We are currently using an Excel file with a VBScript fo…
-
Formula to count of items in a multi dropdown listIn Formulas and FunctionsHi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use …
-
Auto Allocating A PersonIn Formulas and FunctionsHi I maybe asking a bit much here but, here goes..... I want to be able to allocate a person to a task based on the Dept and Quarter No. I have set up a File Review Allocations sheet that shows the number of file reviews required per yea…
-
Does @row work in a summary field?In Formulas and FunctionsI am trying to return a date from a created column based on whether a multiselect dropdown contains a certain value. I'm using If and Has but when I refer to the Created column it does not work
