-
Dashboard breaks after removing an Admin (original owner/builder of Dashboard but not current)
We have a Dashboard (several Dashboards that this same behavior happens on) that was built by one person. The Ownership for the Dashboard and ALL associated items (Metrics Sheets, Reports, Source Sheets, etc.) were transferred to another person. The person who built the Dashboard originally (who is no longer the Owner of…
-
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.
-
if it's possible to allow one editor only can edit a certain rows in my sheets by permission setting
My sheet has several editors and each of them are responsible to maintain infomation of different rows. How to set permission so that they can only edit their own rows and cannot touch other editors' row in one sheet?
-
What is the maximum number of rows that can be added to a sheet?
I've searched for 'Row Limitations' on the help center, and haven't found an article which explains clearly so asking here. What is the maximum row limit (vertical, up to down) on a single sheet? I've seen both 5000, and 20000. Additionally, is there an article where this information is contained?
-
Countdown for days until due but stop counting after due date has passed
Hiya, I am trying to write a formula that will count the number of days until a task is due but will not start showing negative numbers once the due date has gone by. I came up with =NETWORKDAY([Today's Date]@row, [Date Next Check/Validation Due]@row) But couldn't figure out how to make it be blank once the Date Next…
-
Conditional Formatting Across Sheets
Hi, we have a Scheduling Sheet (with columns, wk 01, wk 02, wk 03, wk 04, etc). A Delivery Date column links into this sheet from another sheet. What we do at present is highlight the relevant week column based on the date in delivery date, so for example from Jan 2nd to Jan 8th is wk 01 this year. (See screenshot…
-
Update one sheet using Power Automate on several Excel files?
Hi there, I have a use case where I have a bot creating Excel files daily. I'd like to use Power Automate to tak the data from those Excel files and add it as rows into an existing sheet in Smartsheet so that I can add workflows to the data in those rows. I tried setting up a flow in Power Automate, but was stuck on two…
