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
-
Can I Disable Rollup PercentageIn Formulas and FunctionsHi, I'm working in a Master SS that all departments are contributing information into. My particular project is being run in a separate SS and I'm only pulling 5-6 line relevant line items in and linking them to the Master SS. Those 5-6 …
-
Is there a formula to calculate loan payments?In Formulas and FunctionsI need to calculate the periodic payment of a amortizing loan with level payments and a constant rate of interest. Is there a formula that I can use in Smartsheet to make this calculation?
-
Can Isblank be used for more than one cell?In Formulas and FunctionsI want to show if a column/cell is blank. I've used the formula =IF(ISBLANK([Tutor Name]@row), "Not Complete", "Complete") It works for one cell/column, however I have a range of 5 cells/columns. How do I connect the f…
-
Column formula do not appear in formIn Formulas and FunctionsHello, Hope you all are good in this crazy time. I'm really new in smartsheet and maybe what I'm trying to do is not viable, so I'll try to explain myself as details as possible: I want to create a form with some fields "auto-fillabl…
-
Setting a status based on date fieldsIn Formulas and FunctionsIs there a way that I can update or set a status based on data in 3 other fields? What I am trying to do is set a status based on data being entered in 3 other fields - if those fields are blank, then status would be 'In Progress' if those…
-
Filtering on dashboards?In Formulas and FunctionsI'm new to smartsheet and trialing it at the moment. I have a question, I hope you can help me with: I have a portfolio of companies in a main sheet and their debt issues, and related stuff in several sheets. Rows are companies/debt issue…
-
Issue with countif and find formulaIn Formulas and FunctionsHello, I am trying to have number of projects owned by Project manager I have used this formula : =COUNTIFS({Digital Project Portfolio Plage 1}; FIND("[email protected]"; @cell) > 0; {Digital Project Portfolio Plage 2};…
-
Workflow will not trigger if cell has formulaIn Formulas and FunctionsHi all, I have a sheet with e.g. a cell with a function that calculates someting. The workflow should copy the line if the computed value = 1, but the workflow will not trigger. If I delete the formula and enter manually "1" then…
-
Index Match or Index Collect with multiple criteriaIn Formulas and FunctionsI'd like to return a Contact to a cell if two criteria are met. I've tried using the index collect formula copied below but I continue to receive #INCORRECT ARGUMENT SET. =INDEX(COLLECT({Vendor Contact}, {Project Name}, [Project Name]@row,…
-
Formula column with manual entryIn Formulas and FunctionsHi all, Can I create a formula for a symbol column which would automatically change the priority to a "Low" symbol if another checkbox column has been checked? I would like to retain the ability to manually edit the priority colu…
