Hi everyone, Happy New Year! I hope you're well and safe! I've developed a way to use the newly released Record a date feature to update sheets with today's date automatically without the need to open…
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…