Fairly new to smartsheet, so not sure if I'm doing something wrong.
I have a priority column in my To Do sheet which is a symbol column (High, Medium, Low). I would like to create an IF statement that will automatically change the priority to "Low" once the task is completed (doing this for the
I have a dashboard widget and I'd like it to automatically update every time a row of data is added to the a SmartSheet (see attached screenshot). I'm trying to use a VLOOKUP formula on the top row to always pull the latest data, but it's not working.
When adding rows to a sheet, why does the Dashboard graphs not recalculate the graphs with the new rows? Seems the only way to fix this is to back in the graph and select the new data rows. Am I doing something wrong?
We have a task sheet that uses 3 checkbox columns (Sent, Received or Done, N/A). We have a formula that counts the number of tasks and how many are completed based on the Received or Done column. We are trying to make it so if the N/A box is checked, it automatically checks of the coinciding
I have charts to show progress by week to date, month to date, and year to date. I reference another sheet to indicate the date range for each chart. Is there a way to automate my reference sheet so I don't have to change the dates manually?
Hi, I have an index and match formula set up for 1 sheet and it works great but how do I handle it if I want the index to look at data from multiple sheets to pull the correct information. My current formula is: