-
.pdf no longer open in a new browser tab
Up until today a .pdf attachment in Smartsheets would open in a new browser tab. Today, a .pdf attachment will only open as a preview. We have tried in both Chrome and Edge with the same results. How do we fix this, so that when we open a .pdf attachment it defaults to opening in a new browser tab as opposed to the default…
-
Weekly Count
I need to count values weekly that don't have dates. I need to see progression weekly of how many still remain/left. We have data that's when it's completed it'll remove from the sheet. Needs assistant!
-
I´ve a sheet with a column that describes the date that I would like to receive an alert, by e-mail.
How can I automate this? Thanks for help.
-
Column erroneously dragging over into reports
I am experiencing an issue wherein an unwanted column of data is automatically being included in reports linked to a specific sheet. When I create the report and link this specific sheet, the reports are automatically inserting the unwanted column of data. The unwanted column is not listed under the column dropdown and…
-
#INVALID COLUMN VALUE
I am trying to run some formulas using data including a cell with a date but am receiving an #INVALID COLUMN VALUE error. The cell, which is actually part of a larger data set organized in a column, is linked from another sheet. Both the original cell and the linked cell are formatted as dates. The same error occurs when…
-
Replacing Cells when row is moved to another sheet?
Here you will see my columns, and my archive (2nd sheet) is the same, i have an automation that basically says when the next recurring date has populated and it is -2 days old to move that over to my main sheet, and that is working for me. My question is, is there an automation or a formula where when it is moved back to…
-
Sum of column values that come from function formula
I have created a formulation of a drop down with prices associated with each selection that population on a different column: =IF([Repairs Needed]@row = "Tuck Point", "125", IF([Repairs Needed]@row = "Tuck Point Panel", "450", IF([Repairs Needed]@row = "Tuck Point Column", "150", IF([Repairs Needed]@row = "Tuck Point Major…
-
Progress Bar Automation between 2 Different Sheets
Hi to all you brilliant Smartsheet Wizards! 🧙♂️🧙♀️ I saw a question on here regarding how to "automate a progress bar" and I thought that is perfect for my tracking: Automate the Progress Bar — Smartsheet Community My problem: I want the progress bar in Sheet A under "milestones". But I want it to source the data from…
-
How can I set paragraph line spacing in Document Builder?
I have a series of documents that I have mapped in Document Builder. I need to have the end result with a set line spacing to match the rest of the text from the PDF. I cannot find this setting. I know that I could hard code in the line breaks in the formula, but my issue is that the values in the formula are of variable…
-
AVE or AVERAGEIF when refrencing another sheet
I have my master sheet set up with a duration column. I've been trying to build a formula on my metrics sheet that will allow me to average the duration column based on who is assigned that purchase order. I've tried two formulas, one using AVE and the other using AVERAGEIF and both return the #UNPARSABLE error. The first…
