From a project sheet (with additional columns added) I'm trying to tally up the number of days by resource assigned to each quarter. So I want to specify a Q3 date range between 6/1/15 and 8/31/15, fo…
Hi Everyone, I've recently upgraded to the business version to use the Agile Dashboard tool for a software development project I'm working on, but I'm a novice Agile practitioner and I can't find much…
Hello, I'm trying to generate a report that shows any orders that have passed their ETA without delivery. In the sheet, I have figured out how to highlight the row with conditional formatting, but I'd…
Hi, I am trying to setup a "Stale" notification for a help ticketing system. When a support ticket (row) ticket has not been modified when compared to the current time and date in over an X amount of …
Hello all! I've been trying to create a time entry sheet like many others, but am running into an error with the Weekday() formula. I'm using the formula on a system column for the date/time the row w…
The first column are the dates I complete a task. The fourth column are how many days I have to complete the task. I'm trying to predict the completion date as I enter the dates in the first column. T…
Hi, I have a formula =MAX([Last Modified]:[Last Modified]) + "" for getting the most recent date in the Last Modified System Column to get the latest modification date is for the whole sheet. Now, I'm…
I have a column with 6 options and I am trying to create a statement in another column that says: =IF((Stage1) = "Opportunity", "d73ba1f2-91ba-435e-9480-a2ccf08b36aa", IF(Stage1) = "Contact", "0137cc9…
Hi All, I am trying to replicate the %completion formula in googlesheets in order to understand the value of a project based completion of the various subtasks. Does smartsheets have this ability inhe…