-
% Complete Column
Anyone else having issues? I cannot update this column in any of my sheets. It just jumps to the next line of it you hit return it auto adds a full line.
-
Need Help Sorting & Grouping "Day" Data By "Week"
I'm brand new to functions and Smartsheets in general so please bear with me as I attempt to learn with you all. I've read over the functions documentation and to be honest, it's a little over my head. I'm trying to suss out a step by step otherwise I get lost. But I'm hoping I'll get there eventually! Here's the nuts of…
-
Populating a Dropdown List
Hi, is it possible to populate the contents of a dropdown list from another smartsheet?
-
Index Match Across Multiple Sheets
Hi Everyone, Hoping y'all can help as I'm at a complete loss. I'm trying to pull information into 1 master sheet based on a unique identifier across multiple sheets and it's just not working. I can get it to work for 1 sheet using =INDEX({Status},MATCH([Proj ID]@Row,{Proj ID},0)). Each sheet is for a different team,…
-
Trigger Issue
For one of my sheets, when someone submits a request through a form, I have some rules that assign approvers, and also some rules that assign the number of approvers. These always work fine. Okay, as one example, let’s suppose the number of approvers is just one. I have a Change Status rule like this: When rows are added…
-
Is anyone else experiencing "An unexpected error?"
I am getting an error for most of my reports reading, "An unexpected error has occurred running your report and the Smartsheet.com team has been notified." Is anyone else seeing this?
-
Using smartsheet-python-sdk to put data back into Smartsheet
I used the smartsheet-python-sdk (and unique API key from Smartsheet) to automatically pull data from Smartsheet into my Python script along with other data sources to create new feature-engineered columns. Is there an automatic way to now put these new columns I created back into the same Smartsheet I initially pulled…
-
What happens to my automation if I run out of rows?
Hey there! I am working with a large archival destination sheet: We haven't hit 20k rows YET, but it'll probably be coming this year. The automation moves Completed rows from an active tracking sheet to the archive sheet- we keep that for a full accounting of these completed processes. But.... what happens when…
-
Pie Charts bug? Every series is an [unnamed series]?
Why is this pie chart broken? What is [unnamed series]? It should be "Executive Team" and "Vertical Construction" as the series. This bug has existed since 2018 and it there doesn't seem to be any solutions. Graphing from a grouped report- 'Unnamed series" in legend What's with the "unnamed series" in the pie chart? How do…
-
Date range formula
Hello, How would i write a formula when looking for data between a certain period i.e. I want to find the number of tasks marked 'complete' between March 1 through March 31? Thanks.
