-
COUNTIF with Dates
I am trying to use COUNTIF referencing two Dates columns. The first "Due Date" column has dependencies. The second "Dates" column is simply a list of all possible due dates from the beginning of the project to the end (with no dependencies). I am trying to create a third column called "Total Due" that counts how many tasks…
-
Auto order (by date) in Card View
We have a project workload sheet that has columns of who a project is assigned to, completed, and new. There is no sorting or auto ordering of the projects that happen in each column (by start or end date). You can sort rows in the other views, but not card. Help, please.
-
Multiple Selection on dropdown
Is the ability to select multiple items from a dropdown still in development???
-
Reports Exportable to Outlook Calendars?
Hi there, Are customized reports able to be published to Outlook 2013? Thank you!
-
How do I Subtract a series of days from date column?
I need to calculate a series of dates for a newsletter production cycle. I want to take the Expected Release Date ie: 25 Aug 2019 and in seven column cells, beginning with ten days from the Expected Release date, then show 8, 7, 5, 4, 3, 2 days calculated dates from the Expected Release date. I can perform this easily in…
-
Auto Assign w/in Marketing Request Tracker
I am trying to figure out how to write a formula to auto assign a task when it meets different criteria. For example, my column is "Type of Request". If it is Creative, then I want to assign Kristi from my contact list. If it is Product, I want to assign John. I have 7 different choices within the Type of Request column…
-
IF Formula referencing one column to fill in another
Hi - I've been reading through the community posts and trying a variety of answers, but nothing I've tried seems to be working so I thought I'd post and ask for help. :) I am trying to establish a column that has an answer based on another cell. My columns: Dept Automation Lead So what I'm trying to create: IF Dept =…
-
Average Days
I am looking to have some metrics set up on a dashboard all around average days to close. I have a column for a sales person, two date columns (one a start date and one a close date) and a column called Workflow Status. How can I do the two following things via formulas: * Filter this first by the workflow status being…
-
Phase of Work Formula
Hello Community- I am looking for help with a formula to tell me what phase of work the project is in. The formula will be looking at 5 checkboxes in columns. If I complete the last checkbox in the first phase, but have not completed the last 2nd phase checkbox, I would like the column "Project Phase" to return the 2nd…
-
Export of Reminders
If I have multiple reminders set up in my Smartsheet, is it possible to get an export of all the set reminders together with the content/message I have written?