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
-
Combining IF Formula - Is This Possible?In Formulas and FunctionsHello, I'm working on a formula that will trigger a status of "complete" based on a Task Reviewed column. =IF([Task Reviewed]5883 = 1, "Complete", PARENT()) I am trying to combine the formula with another one that will …
-
Estimating Available Award Dollars when awards have asynchronous start dates.In Formulas and FunctionsBackground: We're a research organization that receives a variety of federal, state, and private awards to conduct research. Awards are received throughout the year with a variety of project periods ranging from 1-5 years. Objective: Deriv…
-
Counting HeartsIn Formulas and FunctionsWe are using a sheet to rate name suggestions. Each employee has their own column and they rate each name suggestion using the heart scale. Does anyone know how to count/sum the total numbers of hearts in a row? Example: I rate a name …
-
Project Dates and Coming in on timeIn Formulas and FunctionsHi, I'm trying to set up a project template using a Gantt chart so that when the Certificate of Occupancy date is plugged in, it will automatically populate the goal dates for all the tasks prior, based on how long those tasks take, in ord…
-
Find Difference between two Cells that could be Multiselect Dropdowns or TextIn Formulas and FunctionsI am pretty advanced when it comes to smartsheet and formulas. But this one has me stumped. I am trying to find a way to report on the difference between two text or multiselect cells. Any advice would be much appreciated.
-
How to display results from original smartsheet in another smartsheet to create a dashboardIn Formulas and FunctionsHello! I am creating an executive summary dashboard for people external to our company. I have a data source smartsheet (primary) that has a lot more detail that I do not want to give them access to. I would like to create a smartsheet …
-
Count number of registrants from each companyIn Formulas and FunctionsI feel like I'm missing an obvious function here. I'm using smartsheet to register attendees for a virtual event. I'd like to add a chart on my dashboard that shows the number of registrants from each company. I know how to do a count if f…
-
Form - Restrict input of a past dateIn Formulas and FunctionsHi, I am re-opening this question to know if any updates have been made since? The question is related to the Smartsheet Form, on having an option to restrict a sender from being able to enter a past date in a form. Related discussion o…
-
Concatenate Existing ColumnsIn Formulas and FunctionsI have an existing sheet with hundreds of lines of data. We recently decided we needed to combine two of the columns, but don't want to have to go through each line and combine them. Is there a formula I can use to copy the information fro…
-
SUMIF Formula Help!In Formulas and FunctionsI am trying to type a sum if formula where it will add up a whole column based off of ONE criteria. The formula is working but it equals to 0 every time when that is not what the actual answer is. Please help! Ex: I want to sum up the numb…
