-
How do you add a recurring monthly task to a sheet?
We have a task tracking sheet where tasks are added after being entered into a form. Some tasks occur on a monthly basis, and we'd like to find a way to have them automatically added to the sheet rather than having to enter the details every month. Is there a way to do this? I've found similar questions where the answerā¦
-
Automatocally changing due dates and status on recurring tasks (Monthly, weekly, etc)
How do I make a row update the due date for a monthly, weekly, and/or quarterly recurring task? I would like it to automatically change the due date to one month, one week, or three months in the future and change the status back to Not Started once a recurring task is marked Complete. I need to be able to do this at theā¦
-
IF and AND for driving progress bar Symbol
For progress column, I want to use the symbol column with bar option (Empty, Quarter, Half, Three Quarter, Full) and it should be driven by task % Complete. if % Complete Value is 0% then progress should be Empty, if complete value is between 0 - 35% then progress should be Quarter, if value is between 36-65% then progressā¦
-
Multiple Emails in Contact List
I have a contact sheet and a main sheet. There are instances when I have 2-3 individuals that need to be notified based on the information on the main sheet. I created this formula to pull multiple emails from the contact list: =JOIN(COLLECT({Department Chairs}, {CourseName}, CONTAINS([APA Courses]@row , @cell )),ā¦
-
Project Schedule Question
I'm looking to make adjustments to my current project schedule. Currently I have an asset due date milestone, a list of tasks with durations and predecessors and a go live date milestone. I am able to put in the partners desired go live date and the formula deducts 6 weeks to determine the asset due date. We are making itā¦
-
Help with SUMIFS
I am designing a budget sheet and want to Sum a series of cells if they meet 2 conditions. 1st I want it to check an expense category, ie. groceries. I then want it to check that it falls within a specific date range. Below is an example of the formula i have built and it works: =SUMIFS({Expense Collector Range 4},ā¦
-
Extracting emails from a mixed contacts column
Hello Smartsheet Community, I'm trying to extract email address from contacts column in my smartsheet, but I am unable to do that. i tried using basic string functions funcitons such as find, trim etc to extract the email part between < > but I am encountering errors. can someone help me with a working formula to extractā¦
-
Formula Help Extracting Month Only from Formula Driven Column
Hi all- I need help trying to extract the month number from another column. My 'Notification Date' column uses a formula (based on the service 'Type') to calculate a specific timeframe. I need to extract only the month from this 'Notification Date' and populate it in the 'Annual Review Month #' column. I was good until Iā¦
-
Formula to only count unique cells, no duplicates
Hello again, is there an =countifs formula that can be used to only count unique cells which would avoid counting duplicate cells in that column? below i want to count W01-W06 only once for the answer to be 6 instead of counting all the duplicate W01 to =8 thanks!
-
Overdue is not working when today date is greater than Overdue
I could use some help with my formula. The "Overdue" is not working when TODAY is greater than Overdue Date. Please see formula below. =IF(NOT(ISBLANK([Complete / Decision Date]@row )), "Completed", IF(ISBLANK([Start Date]@row ), "Not Started", IF(ISBLANK([Due Date]@row ), IF(TODAY() < [Start Date]@row , "Not Started", "Inā¦