-
Merged: Desktop App - Column Prop / Drop-downs Blurry!
This discussion has been merged.
-
Auto-Number Not Working
I have an Auto-Number function running in one column and after number 1966, I added information in the next row, and it spit out the number 1997. I then deleted the information in the row and then added it again and now its 1998. I added another row after and its 1999. I need the next row to be 1967. Any suggestions…
-
What is wrong with this COUNTIFS formula?
=COUNTIFS({Consumer Alerts Sign-up Form Date}, >=DATE(IF(MONTH(TODAY())>=7, YEAR(TODAY()), YEAR(TODAY())-1), 7, 1), {Consumer Alerts Sign-up Form Date}, <=DATE(IF(MONTH(TODAY())>=7, YEAR(TODAY())+1, YEAR(TODAY())), 7, 31), {Consumer Alerts Sign-up Form Range 1}, @cell = "") I am trying to create a COUNTIFS formula for each…
-
.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…
