I am very new to smartsheet. What formula would I use to count how many times the year 2021 appears in the blue (parent) rows? I also would like to make a formula for a metric sheet that automatically…
Hello, new to Smartsheet so might not use the correct language, but hopefully someone understands what I need! In my company we host CPD sessions where suppliers will come in for an hour over lunch an…
I have a simple sheet summary formula that keeps returning "Invalid Operation". I am wanting to count the number of instances where the Potential Loss column is over $500. I've tried every variation o…
I am using a helper sheet to calculate projects that are Past Due, Due this Week, and Pending Review per Requestor Email (this email comes via a form). The formula I am having issues with is the the o…
It would be great to have user definable fiscal quarters in the new Timeline view. Also, as I am creating this discussion, there isn't a tag for Timeline View yet 😁
Hi! Before I start, I want to say that I'm still fairly new with formulas, so it's very very possible that this error just might need a slight fix, but I need a bit more assistance with what I'm speci…
Hello! I have an overview sheet where each job is it's own line and each column is a specific milestone I'd like to track that is linked back to the source timeline. I created a report with just the j…
I have a form where a user identifies all the people from different departments and input their names in the Team Column. There are times when people are not filling it out for various reasons (wasn't…
Hello, I am trying to figure out how to change the WBS phase number for specific tasks in my project. For some reason a group of about 15 tasks is assigned to phase 1 in my WBS, but they should be pha…