-
Using a modifier to derive month (formula de-bugging help
Ok. so I've set up a rolling dashboard built around the today function - something like this. Everything rolls over automatically as it all references TODAY() to determine the various derivatives. (see screenshot) It's great, but doesn't scale (yet). The Month column uses this right now - =IF((MONTH(TODAY()) + Modifier5) >…
-
Countifs with find
I have 2 columns (Stage) and (Courses) Courses is a multi dropdown, stage is a single drop down. I want to count how many people are invited to Fundamentals 1 vs how many have completed or certified in a rollup sheet. I am either getting unparsable or invalid This is on a rollup sheet that points to the working sheet.…
-
Formula For Finding Quarter
Hello, New to smartsheets I have been using excel extensively. Can someone pleased teach me the formula for finding a quarter based on a date? For instance [Date Data Column]1 = 1/1/2016 I want the formula to return "Q1" in the [Quarter]1 cell Havent been able to figure this one out...help please!
-
Count of Completed Tasks by Month across multiple sheets
I am trying to get a count of completed tasks by a team by month across multiple sheets. I've created this formula in the sheet summary: =COUNTIFS(Status:Status, "Complete", [Team Assignment]:[Team Assignment], "Lean"). If I'm trying to get a completed count of tasks for the month of September, how could I get that count?…
-
Roundup causing error on reports
Hello, I added the new roundup formula to my sheet and this cause all of my reports that reference this column to show up as #unparseable only on the report. This shows as a value on the main sheet. To make this worse any other formula on this sheet shows up as #blocked until this is removed
-
Importing\Uploading Information
I know you can create a sheet by importing a document into SmartSheet and having it auto-create around the information; however, how do you continue this? IE You take a sheet from Excel, that will continue to be used, and import it into SmartSheet, then you want to update the information in the SS later by just…
-
Inventory
Is there a training video to show us how to do the inventory and features? We want to use this feature but I need some training.
-
Recording the date of a specific update and locking that date?
Greetings SMARTsheeters... Not sure if what I'd like to do is possible in SMARTsheet, but here goes... I'm working on a SMARTsheet that receives data adds and modifications from SMARTforms and autoupdate email requests. There will be various users entering and modifying the data in the SMARTsheet adhoc through these forms…
-
Return 1st column value if 2nd and 3rd column is blank
Hello, I am trying to come up with a solution for my smartsheet involving 4 columns (4th being the result column). I wanted to return the value from the 1st column whenever 2nd and 3rd column are blank, if not return the value from either 2nd or 3rd column. These columns contains dates by the way. Sent (1st) ; Won (2nd) ;…
-
Changes Report
Does anyone know if there is a way to produce a report or a list of rows whereby Column A has changed in the last n number of days? I'm trying to produce an exec level weekly report of key projects whose end dates that have changed in the last week.