-
Formula for today's date
How can I include today's date in a report or sight?
-
Web Form Reminders for New Request
I want to use the Web Form to collect agenda topics for weekly meetings. I have the form setup but trying to figure out how to send it out as a weekly reminder for people to add their new topics for the next week meeting. Thanks, Kat
-
Reporting in Parent/Child format
Hi folks I have a simple sheet with many columns. It tracks all the projects we have and what stage they are in. The parent child relationship looks like this in the primary column: Project A Initiation Planning Execution Closeout For my report, I'd like to still show that relationship so that the gantt chart can be…
-
Date Counter for Weekly Ontime Rate
Hi there! I need some help coming up with two formulas that will count how many times in the week we hit our projected due date and how many times we are early. I already have a hidden column that looks at the date and calculates the week of the year. I need the fomulas to read something like: count if 'date completed' is…
-
Subgroup within Drop Down List
Good Afternoon Everyone, Hoping someone has some tips for me. I am creating a smartsheet with a webform for our marketing department to help obtain and organize work order requests. On this web form, I have a dropdown list for the client to specify where the request is for (we have numerous hotels, retaurants, attractions,…
-
Formula that only counts business days
Hello, I'm trying to write a formula for a date that will say something like "due in 18 business days". So basically " =[column name] + 18" but exclude weedend days. Is that possible? Thanks so much!
-
How can I write a formula to summarize in parent row summaries in child rows?
Column is entitled Status and is a drop down list with the following selections: Not Started In Progress Delayed Cancelled Complete I have a formula in each child row to summarize grandparent rows: ="Not Started (" + COUNTIF(CHILDREN(), "Not Started") + "), In Progress (" + COUNTIF(CHILDREN(), "In Progress") + "), Delayed…
-
CONCATENATE Formula Help
First, I had the following formula to return the number of tasks marked done over the total number of tasks (i.e., 10 / 50 complete) , then realized Smartsheet did not support the CONCATENATE function. =CONCATENATE(COUNTA($[Done]$2:$[Done]$51) "/" COUNTA($[Task Name]$2:$[Task Name]$51)," completed ") So, then, I tried the…
-
Date created as start date in Calendar range
Hello, I'm trying to use the system generated creation date as a start date for a range in calendar view. For some reason it's not recognizing the column as a "date" column? Any ideas on how to make that work? Thanks. - Eric
-
Finding cells that aren't linked
Hi everyone. I have created a mastersheet (A dashboard), where i link cells from 10-15 other sheets (Project sheets). What i want to do is to create a report, that will "catch" any rows that are added withing the project sheets. Basically what i want to do is to keep my Dashboard up-to-date when changes happen in the…