I am attempting to do the following. If the "Completed" column has a check, in the checkbox, I would like the % Complete column to read 100% Here is the formula I thought would work using task 4.of th…
I need to write a formula for counting active projects that are past due for a current month based on schedule complete date being in that current month and when actual complete date is blank. Project…
Is there a way for admins on workspaces to be able to rename them, or is it only workspace or sheet owners that can do this? Since the admin has full sharing/editing rights, it would be helpful to hav…
I have two task lists with slightly different columns, but there are some overlap - like status, completion date, & targeted completion date. I would like to run a report or some how combine all the t…
Client submits file through form. I have an automation set up to respond to client when new file w/response is attached to row and "Status" and "Date" cells @row are populated. It works as intended bu…
We planed a rough schedule for our project. Now we need to plan new, because of the changes in the project. Also we want overlay the old plan with a new one so we ca see consequences. So I could see i…
Hello Smartsheet super formula humans! I need some assistance! We are trying to create a formula where a checkbox is checked if the project meets the below criteria. Recurring On hold Pending approval…
We've launched a new group for Smartsheet Control Center users! We hope this is a space for you to find answers to your questions, provide help to others, and connect with people with similar interest…
Hello, I've had a colleague come to me with a query about how best to link 2 sheets. Her enquiry includes a handy diagram: I'm wondering if cell linking would be best bet here? I realise this would ob…
Hello Gentlemans , Do someone can give direction on how to count tasks "on fly" per work week. Example; task start 28.07.20 finish 28.08.20, this task will include in count WW31,32,33 and 34 till its …