-
Formula help
I have a request for time off form, when a request is submitted the person is notified that if they do not receive a response within 5 business days they can consider this approved, however I would like to create a formula that is based off the auto created date so if Approved column (where supervisor notes if it is…
-
Comments change
If you have multiple users, can they see if there are any changes to the comments? new repply, new comment added? Also If there are any changes done, like new tasks, new status, is it possible for other users to quicly indenfy those changes? thank you
-
API: Copying only specific columns within a row
I want to copy a row from Sheet A > Sheet B. Sheet A contains several columns that Sheet B does not. Currently, moving the row results in Smartsheet automatically creating the ommited columns in Sheet B and dumping them at the end. Is it possible using the API, to select only the columns I want to move? Or to somehow…
-
Counting non blank cells in a row till first non blank.
I need to count blank cells in a row, left to right, till first non blank cell. the non blank cell may contain any character/s or digits. Any suggestions? For instance this formula will work to count blank cells till it finds X in row 1, columns 1-20, but not anything else: =MATCH("x", [Column1]1:[Culumn20]1, 0) - 1
-
Sheet showing blank
Hi All, I wonder if someone can assist me. I created a sheet by importing an Excel workbook. When I open the sheet via SS, it shows blank. But when I click on the link as in the email I send for the Invitation to VIew to users it opens up the sheet and all the data is there. I am concerned I know to click on the link but…
-
Adding expanded comments to sights or reports
If people are using the Comments column to provide status updates on line items, can those be expanded somehow in sights or reports? Or do I just need to add a column for Status Notes in each project sheet that I have?
-
dependencies
Dear SS friends, sometimes i can start a second task half way though the completion of the first task although not before the first task has at least started and progressed some way. Is there a way I can have dependencies that can start part way though the dependent task? Hope this is clear! :/
-
Sharing Reports
My coleague cannot see the content of a report that I have shared with them. Why is this?
-
Can i filter and search based on column values?
hi I have a column that has text. Can I serach and filter that column to show only row that has that text? thanks
-
I want to utilise an IF THEN function in Smart sheet
My example is to select a cost rate based on the employee title. If [cell1]="welder" then [cell2]=80, if [cell1]="crane operator"then [cell2]=100, etc, etc.
