-
Agile Backlog and Sprint Dashboard
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 training about how to build and use the dashboard tool. Does anyone have any ideas about videos or other training? Thanks.
-
Cell to test if an ETA has passed without an order delivery
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 like to extract the order essentials into a report that I can surface to three different managers via a portal/dashboard.…
-
Stale time/date
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 hours, then send a notification. I can compare two different date columns like this: =Modified1 - [Created Date]1 But if I…
-
Weekday Formula Error?
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 was created. I have an entry for 01/22/18 4:20 PM, which returns "2" for the weekday value. Right after I have an entry…
-
Added IP Management Functionality
Any Chance of adding this type of Functionality to Smartsheets: https://www.codeproject.com/Articles/712335/Followup-DNS-Lookup-and-Ping-in-Excel
-
Predicting a Date based on what type in as I complete a step
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. The expected completion date will move up or down depending whether or not I finish the task on time or a few days earlier.…
-
Sheets Last Modified
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 trying to gather all those Dates and Times to get the most recent change in multiple sheets. However, upon linking them and…
-
If Statement Help
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", "0137cc9c-51b4-40fb-bf06-73174c348733") I have 6 total stages but can't seem to get this to work. Any advice? Geneva
-
formula for the %completion in parent
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 inherently? The project guys always think they are further along on the project than they actually are and this is artificially…
-
Formulae help....new to Smartsheet
Hi everyone, I am a new user to smart sheet. I need to do a sumif calc based on two columns of data being 'unticked' so I want to show the sum of i.e Column D but only if Column A & B remain unticked. When a cell is ticked it means that the work has been complete etc. Any help/advise would be greatly appreciated.
