-
Using Smartsheet as a datasource in Sql Server Report Builder
Hi there. To keep it simple, I'm looking to use Smartsheet as a datasource to build an SSRS report. Has anyone done this successfully? If so, are there any special needs such as a driver to pull it off? Any knowledge on this is appreciated. SB
-
Proper Syntax for IF and VLOOKUP
I am trying to create a formula that will run VLOOKUP if a cell is blank This doesn't error but it leaves the formula field blank =IF((USERR3 <> ""), (IF((VLOOKUP(SDR3, {SFDCUsers Range 1}, 2, false)) = 0, "No", "")))
-
Dependency based on Status rather than Dates
Is there functionality available, in Grid View, that will allow you to identify tasks as dependents of other tasks, based on a Status field rather than a date column. We have many task related projects that are not tracked by dates but are tracked by status.
-
Can Smartsheet automatically highlight / notify if a reference appears on a sheet more than twice?
I am literally new and learning Smartsheet and have set up a customer order form but each customer can only have a maximum of 2 free orders so i was wondering if it is possible to automatically flag if the same reference appears a third time? At the moment i am exporting to Excel and using a countif function to check for…
-
Column Formula Question
Is it possible to convert a cell formula to a column formula if it references a different sheet? Here is the formula in question: =VLOOKUP([Project Name]@row, {AM Master Info List Range 2}, 5, false) Where [Project Name] is a column in the current sheet, and {AM Master Info List Range 2} is a range from a different sheet.…
-
Conditional quantities for pricing sheet?
Smarties, I am creating a pricing form and am stuck on a formula. In the example, the first 4 widgets cost $10. Each additional widget is after 4 widgets is $3. In the preceding cell [1-4 WIDGETS], I have a single-select dropdown of 1, 2, 3, 4, 5+ (as I need these numbers to count the number of widgets sold for another…
-
Can I create a report/Sheet that would capture all conversations on multiple sheets in a workspace?
I have multiple sheets(Representing a job) in a workspace that have conversations. I am wanting to combine all of the conversations into one report or sheet to see all of them in one sheet. Can this be done?
-
Can multiple users make updates at the same time to a report with a 'has any' 'current user' filter?
Hi, Background: I have multiple Smartsheet files with around 1000 rows that each involves around 20 assigned individuals with various technology literacy. Due to assignees various technology literacy and to maintain the integrity of the Smartsheet file, I've created an individual report per assignee that is filtered by…
-
Reference Predecessor Cell / INDIRECT Function
I'm using a formula to automate a status column that updates based on dates and/or a "Complete" checkbox. The formula has to reference the task before and I've gotten that to work just fine if it's the literal task before. My problem is that I'd like to adjust the formula so that it references a predecessor task (as…
-
Linking between different sheets.
Hi Everyone, I have a roll up sheet in which we have linked data from individual project sheets. Some data from project 1 will be row 1 in roll up sheet, project 2 will be row 2 and so on. One of my team members filtered the data in roll up sheet and when the filter was removed, all the data in roll up has disappeared (but…
