-
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…
-
Find previous date for then calculate days between dates
Hi all, I'm having difficulty creating a column that shows the number of days between jobs at the specific venue. Sheet is essentially a list of jobs at various venues. VENUE A, 02/02/23 VENUE B, 10/02/23 VENUE C, 15/02/23 VENUE A, 16/02/23 The column I'd like to create would show the last row for VENUE A as 14 days. I'd…
-
Is there a way to restrict number input to positive numbers only in a form?
I'm building an approval process/workflow for a finance team and I'm curious if there is a way to restrict number inputs to positive numbers only?
