-
Can a column be formatted for HH:MM entries?
I need like to track working hours in sheets so it would be helpful to format the columns as an hh:mm entry, is this possible? Thanks
-
Access Issues with Smartsheets?
Hi All, I have a paid license on Smartsheets and need to invite free users to certain spaces/documents to collaborate on work documents. However, when I share to users (both free and paid) with admin or editor access, they can't edit the document and have the 'view-only' version. I've tried contacting Smartsheet with no…
-
Can a range be specified with a beginning and no end?
I'd like to create summary rows at the top of my sheet, but specifying the entire column as a range in the formula is causing #circular reference and #block errors. Is there a way to specify a range from row 25 to infinity? I'd like additional rows to automatically be included in my summary calculations. The formulas I'm…
-
Formulas with multiple inputs in smartsheets. Help needed!!
This has been a challenge for me to figure out using the smartsheet platform. I am developing what is essentially a big calculator. The formula that I am trying to implement is: [($26,000 * DTH) + (Risk R * Repair Cost) + (Risk A * repair cost)] * frequency). In this database, each row represents an additional input. The…
-
Is there a way to have Smartsheets automatically sync to a Google Sheet?
Hi, We have need to Automatically sync data from Smartsheet into Googlesheet, please advice, how this can be achieved. is there a way to have Smartsheets automatically sync to a Google Sheet? Please advice. tx Dhananjay Nagarkar
-
Automatic refresh after another person makes change in sheet?
Hello all, It seems that a sheet will automatically refresh after a fixed period of time, assuming you have no unsaved changes, when someone else has made a change to the same sheet. It'll give you a pop-up message and then display the refresh icon next to the sheet title. Does this happen after a specific period of time?…
-
Automate the Progress Bar
Hi there Smartsheet Guru's! Im trying to figure out the best way to automate a progress bar, based of 9 columns that all have check boxes. Screenshot shown:
-
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…
