I am having trouble with a formula that contains multiple "If(contains)" function. The following returns unparsable. =IF(CONTAINS("52", [Account #]@row), "52", IF(CONTAINS("53", [Account #]@row), "53"…
Any suggestions on how to make this exceptions formula more accurate? Smartsheets keeps adding 10 rows to my sheet with no data causing my formula to be off. I have 88 rows with data and a total of 98…
I have a list of items for sale in (column A) in a dropdown list to be used in a webform.... IE: Dress $25 Pants $50 Shirt $30 I want to have the total cost of the selected item (single select in the …
I am working with three sheets for this project: Sheet 1 - Open Projects, Sheet 2 - Finished Projects, Sheet 3 - All Info. When a project moves from "Open" to "Finished", it is moved automatically fro…
Greetings- Im trying to do metrics and a graph for individual items that may be selected as part of multiple items in 2023. For example, my form has the option to select one or multiple from the list:…
I have a Smartsheet that I have populated with INDEX MATCH, and it works great. My last column is to pull in the email addresses of all the employees, based on their employee ID that has previously lo…
Hello, I want to create a dashboard widget that will show employee FTEs for the current month. I currently have a sheet (Capacity Plan) that list out the employee's name, and then has the assigned pro…
I created a formula to try to create an indented structure for reports by concatenating multiple "tab' characters based on the indent level. However, the formula doesn't work as expected. Instead of e…
I am sure there is some simple answer, but I brain hurts. We are developing calculations and metrics to quickly assess the status of a project. I am trying to find the percentage of Critical Path task…