-
Custom Views
Hi everybody, this is probably not a new one, but I've not been able to immediately identify the right thread - therefore let's try again: We've started a new sheet with some intense collaboration, and everybody has his preferred view in the meaning of what to collapse and what to extend (preferences as well change over…
-
HELP! RYB Color Change Based on Dates
Hello everyone, I am currently using this: =IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 >= Completion4, "Green", IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 < Completion4, "Red")))) Which is working but I try to add this: IF(ISBLANK(Completion3), IF(NOT(ISBLANK(Supervisor4)), "Yellow" And it doesn't work, I'm…
-
SUMIFS with OR and Date range
I am referencing another sheet for this, and this formula currently works... =SUMIFS({SALES Range 1}, {SALES Range 5}, "DK", {SALES Range 2}, "Don Joy", {SALES Range 3}, "paid", {SALES Range 4}, >=DATE(2019, 1, 1)) That being said, I need to embed a logical expression as to include multiple criteria for {SALES Range 2},…
-
COUNTIFS Multiple Criteria and Checkbox - #INCORRECT ARGUMENT SET
I am having #INCORRECT ARGUMENT SET error message with this COUNTIFS. Please help. I am trying to Count Client Name column if both criteria are met. 1) Client Experience Manager = "value" 2) Terminated checkbox not CHECKED =COUNTIFS({Client Name}, {Client Experience Manager}, "Joe Smith", {Terminated Checkbox}, 0) Any help…
-
Master Roll Up Sheet and Reports
Hi there. I'm still rather new to using Smartsheet and am being tasked with really thinking outside the box to creatively build views and reports with Smartsheet. I am currently working on a project where we have 8 auditors (with 8 separate sheets of their own). Each of the sheets has categories and subcategories of the…
-
Unparseable Error
I am trying to create a formula that will return different values based on multiple factors, and the information on the sheet is linked in from another sheet my sheet is attached and the formula I am trying to use is below. Any help is greatly appreciated Here is my formula =IF([% Complete]1 = 1, "complete",),if(and([%…
-
Excel Import Truncates My Index Column (Strips all Numbers except 1st one)
I am a brand new user...I imported my resources into a sheet using an excel import. My Index Column was truncated, any idea how to reverse this or stop it from happening?
-
Metric sheet that feeds dashboards
Hello, I am looking for best practices for setting up a metric sheet to feed a dashboard. I haven't found anything in help. I've set up sheets with my formulas to pull data from various sheets and then use that data for graphs, reports for dashboards. I've caused myself problems while sorting and wondered if there is…
-
Multiple Projects - Resource Overview
Hi, we are using Smartsheet for managing our Sales Pipeline. As soon as a project is ordered, we are using the same line to gather project information related to execution. I would like to add a Gantt Chart to each lien (via Hyperlink to another Smartsheet) in one cell with resources. Question: I would like to see a…
-
Smartsheet Merge and Transpose
Hello, I have two sheets. One sheet is a list of items to be offered at a charity auction with a different row for each item and columns with specific (Item number, donor, minimum bid, winning bidder number, cost etc). The 2nd sheet is a list of the bidders with a sum of the total that they have bid (bidder number, count…