-
Counting dates not working
I have 2 sheets. A Master data sheet (sheet 1) and a 2023 blackout calendar(sheet 2). What I am trying to achieve is a formula that counts how many times a date has been scheduled in my master data sheet 1 [Installation Date], which matches/references the 2023 calendar in sheet 2 [Conversion Date], and bring the count into…
-
Visual indication of child rows when mouse hovers over the +/- icon of a parent task
Use case in mind: Working within a complex project plan containing lots of hierarchy. (Possibly with outdated and messy content...not all of us PM's are perfect =/) Having to open and close parent tasks often as you build out or make large structural updates to a plan. Opening and closing a parent task can be a bit…
-
Formula to copy contents of a sheet to another
I’m new to smartsheet and am trying to figure out a way to call contents of a sheet to another based on certain criteria, something similar to what Filter function does in google sheets. I am aware that I could achieve this using the index collect function, however the data I am trying to call goes in hundreds of rows. Any…
-
Allow Fuzzy Logic in Lookup Value Columns
Currently when typing in a lookup column, the list is only shortlisted to the first character(s) of the values in the drop down. It would be greatly improved to allow fuzzy logic as do forms when search via the drop down values for shortlisting. This feature should also be supported in Dynamic Views. Currently, Dynamic…
-
Is it possible to create bulk/multiple sheets using Create Sheet API in a single call?
Is it possible to create bulk/multiple sheets using Create Sheet API in a single call? FYI: I am aware of looping the request to create multiple sheets, but how can I perform bulk creation within a single call? Please help me with knowing how to achieve this. The response schema in the API documentation allows me to think…
-
Best way to assign many items to multiple people?
I have a Smartsheet with some 700 rows. Each row needs to be assigned to a set of individuals. I will be doing this monthly and it took ages to set up the first instance. I thought making groups would help but apparently not. How can I make these assignments most efficiently, please? And what is the point of Smartsheet…
-
Combining IF/AND/OR to return a value when multiple criteria are met
Hi Everyone, I am trying to filter out tasks on my Gantt chart occurring over the next three weeks. We found a good combination of filters that works for reports, however I want to be able to create a filter like this for the sheet so that the tasks can easily be edited in real time. Sheets do not allow for the hierarchies…
-
Sheets display up to 100,000 cell link indicators
Hi Community! In August 2022, we limited the number of outbound cell link indicators a sheet can display to 1,000. This change was made for product performance reasons, with no functional impact to your sheet links except for the removal of the visual indicators. Since then, the engineering team has been making significant…
-
Automatically add dated rows to a sheet
We manually create metric summaries to report out monthly metrics to more easily chart monthly measure data. That summary sheet has a format like below and each row contains SUMIF formulas that aggregates data from other sheets: Month_Ending (Date) : Metric1: Metric2: Metric3: Metric4 Currently, this process requires that…
-
Can't open/attach/download attachments in smartsheet
Hi Everyone, Is anyone know how to fix this error: This site can’t be reached Check if there is a typo in s3.amazonaws.com.DNS_PROBE_FINISHED_NXDOMAIN It prompting everytime I am opening attachments in any of my sheet and when I try to download or attach smartsheet doesn't execute anything. Please help.