-
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…
-
formulas to reference sheet in multiple lines
Is it possible to bring information to a sheet from a reference sheet column but have it list the returned information out in separate rows? I have a source sheet with many rows that are sorted by status. I want to list out the job numbers AND the job name in another sheet, ideally side by side one on each row. I would use…
