Hello Community, We’ve published the following new collection of articles that highlight specific capabilities for builders: Basic Builder Learning Track: Intake to archive Basic Builder Learning Trac…
Hello, I have had issues with my dashboard charts changing colors when values drop to 0 and then come back above 0. It changes everything and I have to manually fix this issue. I found a solution on t…
I need to count rows if “Target Start” is between the Friday before last Friday and last Friday, “Work Type” is "EMERGENCY”, “Work Order” does not contain “IMP”, “Status” is not one of “Cancelled” or …
Hello! I'm still a beginner smartsheets user, and while I am decent with excel the live updates is still very new. I'm trying to create a formula that will pull information on a weekly basis, M-F, tha…
I'm trying to do a countif formula between a specific range of years, while referencing from an alternate sheet. This is the sheet with all my data (of course, just a small example) And this is the ra…
Hello everyone, I am tasked with tracking budget moving forward and would like to be able to track overall budget but also budget for each POs. I would like to have the formula to add the Children's C…
I am trying to combine all of the data into one cell for a row, but also any additional rows that share the same PO #. I then plan on taking this information and moving it to another sheet in order to…
Hello, community! I have a question. I'm using the "IF" formula to calculate a percentage based on the status in the "status" column. now, I'm trying to calculate the average of those rows, but I get …
Hello Community, We’ve published the following new content: Using helper columns in Smartsheet Control Center: Troubleshooting FAQ To view the entire catalog of help articles, visit the Help and Learn…
I am trying to figure out how to pull the data from a different sheet to build my roll up and dashboard. I am trying to use the following formula. The goal is to be able to show how many submissions t…