-
Email Error
I have an automation set up so when a certain column is checked it will generate a document via DocuSign. It worked perfectly and now suddenly I keep getting the same error. I have scrapped the automation and started over making sure everything is set up correctly but still get the same error: The email for "Doctor Email"…
-
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…
-
Cannot renew my Smartsheet Business plan!
Hi It's been well over an hour and every time I try renewing my Smartsheet Business plan, the following error message appears "Sorry we ran into an error" I tried renewing my plan using different payment methods but nothing worked. Can someone please help? All my work is stuck because of this non-sense experience. Thanks
-
Unable to Access WorkSheet
Last night, everything was functioning perfectly while I was working on a sheet. However, this morning, I'm encountering an error message (Error 48) whenever I try to open the sheet. It's visible in the folder, the error persists on different devices and platforms. If anyone in the community has experienced a similar issue…
-
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…
-
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.…
-
#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…