-
Looking for a labor capacity tracking solution - SS Resource options won't work
Hello, I've seen a few people asking questions that lead me to believe I am not the only person looking for a labor tracking solution NOT at the day level. To use the resource tools in SS we would need people to estimate their workload on a daily basis with start and end dates. We want people estimating hours per week per…
-
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…