-
Metrics Sheet - Restrictions
I cannot for the life of me recall how I set up metrics sheets when I was at my previous company! My circumstance is that I have approx. 150 TDLs (they are like account #s), each with their own sheet in Smartsheet. And I need to count certain columns. They would be like doing a COUNTIF within Excel. The top screenshot is…
-
Pivot App is not recognizing the Contact Columns
We had a lot of pivot tables built from Contact columns but all were showing blank now, when I test manually by creating a new pivots I see contacts columns were not recognizing in the pivot apps, all summaries were grouped under the Blank row. Here is my example eCOA Implementation PM is a contact column and have lot of…
-
Formula & Placement for Automating Status based on End Date
Hello Smartsheeters! I would so appreciate your help with this - I'm watching all the videos/reading the help articles, but I'm still not getting it! Goal: Automate Status column updating When the Status of a task is not changed to 'Complete' one day after the row's 'End/Due Date,' I want the Status to change to 'At Risk.'…
-
Formula & Placement for Automating Status based on End Date
Hello Smartsheeters! I would so appreciate your help with this - I'm watching all the videos/reading the help articles, but I'm still not getting it! Goal: Automate Status column updating When the Status of a task is not changed to 'Complete' one day after the row's 'End/Due Date,' I want the Status to change to 'At Risk.'…
-
Formula error when trying to collect the next task due end date.
I am currently using the formula: =INDEX(COLLECT(Task:Task, Level:Level, 2, Status:Status, <>"Complete", Summary:Summary, 0), 1) to collect the next task due that is not completed for my summary section. I now want to collect the due date for that task. I have a column for "End Date" but not matter what formula I do, I…
-
VLOOKUP Help - Incorrect Argument Set error
I am stuck with an "Incorrect Argument Set" error when I try to use VLOOKUP. On Sheet 1, I have a column called "User Name." I am adding a helper column tacked onto the right side of a large timesheet report pasted in from a .csv file. I'd like to use VLOOKUP to retrieve the user's name as it appears in my payroll reports.…
-
Selected data cannot be charted - shouldn't be happening
I have a report that I want to use as a data source for a chart on a dashboard. The report has summaries and the required grouping so that the top-level row of data can be used for the chart. Even though there clearly is numerical data for a chart to be created (see below), I am getting the error - "Selected data cannot be…
-
#NO MATCH result but not for identical formulas
I have two formulas that are fairly identical but one is producing a #NO MATCH error. =COUNTIFS(Shop:Shop,Shop@row,[Review Start Date]:[Review Start Date], YEAR(@cell)= YEAR([Review Start Date]@row)) This works just fine and returns the proper counts. The Shop column is a number/text field - and the Review Start Date is a…
-
Smartsheet Outage Banner: Please add one to affected pages/Plugins
When Smartsheet has an outage, yes, we can check status.smartsheet.com to check the status. However, I think it would be helpful to users in smartsheet to know when an outage affects what they're working on. For example, I spent a long time trying to fix a bridge error I was experiencing yesterday. Today the Bridge flow…
