Want to practice working with formulas directly in Smartsheet?
Check out the
Formula Handbook template to view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
Product questions?
Ask it here! The community's got your back.
Discussion List
Freezing Dates
I am looking to have a blank cell populate a date in a column using an if statement to check for specific values in another column. With excel I would normally use a circular reference to check if(and()) the cell was blank and that the values I want are in another column, and then populate a today(). With Smartsheet it…
VLOOKUP Output Doesn't Match Expected Value
Hey Everyone, I've been having a hard time with some missing features or current limitations within SmartSheet but have found the communities helpfulness in finding various work arounds very useful. I'm hoping that somebody will have an idea for the issue i'm currently running into now. Having made some helper columns…
Text String Help... Again!!
Hello All, feel like I am always asking these text string questions but they are so confusing!!! I have a list of retailers and I am trying to just extract the Name of the retailer between either the 1st and 3rd "-" or the 1st and 2nd "-". The problem is with how some of these are formatted like the first one and second…
=netday
Hi, I'm trying to get =netday to work but I keep getting "invalid data type". trying to see how many days it takes to review from the starting date to closing date of review this is the formula =NETDAYS([Tissue Received]@row,[Final Donor Disposition Date]@row
VLookup or Index from another sheet with 2 criteria
I have a sheet where I want to return a score per manager per question asked - in the yellow colomn: The data sheet is structured as follows - for the vlookup or index formula it needs to return the score for that Manager (Final Team) and the corresponding Question Name: Please help with the formula!!
Is there a formula that can be used to bring over a Row ID from one sheet to another?
I have a sheet that we enter all of our training data and each row that is entered is automatically assigned a ROW ID. We have another sheet that will bring over the information affiliated with that ROW ID. Right now I am cell linking, but I have to link the new cells as they come in. I would like for the ROW ID to…
Can someone tell me what I am doing wrong in this formula to set the status ball color?
=IF([Estimated or Actual Finish]@row>Finish@row), "Yellow", IF(AND([% Complete] < 1, Finish@row < TODAY()), "Red", "Green")
Formula to return User Name from Created By
Is there a formula to return User Name from Created By?
ISCRITICAL
Has anybody in Smartsheet EU successfully used ISCRITICAL on a gantt please - we have been trying, and every single time it's coming with the error "Incorrect argument". The formula is simple enough =IF(ISCRITICAL([Task Name]@row),1,0) Thank you
Multi option & contact pull
I have a form setup so that users are able to select multiple countries from a drop down list. This then shows correctly on my sheet as intended. Assocatied with these countries there is a contact as well so need to link the two together so that when a country from the list is selected then the right contact name/email…
Help Article Resources
Trending in Formulas and Functions
Why is 'DAY' Value from a Date being populated incorrectly?
I have a 'Formatted Date' column with a column formula (below) that formats the date from the row's date timestamp, which I renamed to 'Training Completion Date', into DD-MMM-YYYY format. All rows but one is getting the correct day from the DATE. I cannot figure out why 10/08/24 returns 9-Oct-2024. Curious to know if…
Counting items in a cell separated by comma
Hello, Thank you in advance. Need help getting the count of the values in a cell that are separated by a comma. Example in a Cell I could have three values: Blue, Green, Yellow. Need to return the value 3 but I can't seem to find that anywhere in the community. Thank you again!
Need a formula for % complete for all phases on the parent project summary row. Row is non editable
I need an average formula in the parent project summary (row 23). Formula should include all phases (initiating, planning, executing, closing). The parent row is un-editable and not allowing me to enter a formula.