-
Google Sheet Sync into Smartsheet
I realize Smartsheet allows sync for Google form; however, does it allow sync for Google sheet and vice versa?
-
Pop ups
I used the dashboard as a way to communicate to many within our organization, as many of you do. Recently, this week, it looks like now when anyone clicks on any link within the dashboard a new window opens rather than a new tab within the same window. Also the new Tab is not expandable. I do not have this issue on any…
-
automatically export and then delete rows
We use SmartSheets to collect a large amount of data using a form. We reach the Smartsheet size limits almost weekly. Currently we log in each week, export the data to excel, and then delete rows based on a date criterion. I have looked at Zapier. It looks like I can have it email me the data in excel but the free version…
-
Auto-hiding rows
Not sure if this is possible, but I would a row to become hidden based upon the status of a drop down. If cell is blank, nothing needs to happen. If cell is "delete" or "archive", I would like the row to become hidden. Any help would be awesome.
-
Finding and returning values in a range of cells
Hi all, I'm having a lot of trouble joining cells that contain a certain value (because there is no contain function). I have a range of cells that are all in a single row, and I'm trying to collect all of the cells that contain a certain value, and join them together. For example, say I had a row with 4 columns that say…
-
How to track items that are completed after their due date
Hello! I'm trying to track tasks that are completed after the due date. I used this formula to indicate when an task was past due and not complete but once the task is checked off as complete it no longer works, well it works it just doesn't give me the data I'm looking for. =IF(AND(TODAY() = DUE5 + 1, Done5 = 0), 1, 0)…
-
Status Change if Column Checked
Hi everyone, I need some help with a formula that just doesn't want to work for me. Currently my status column changes according to the {Proof Approval - Kim} column. It works fine (formula shown below) Now I want to add on to this formula so, if the column {Out For Approval} is checked, I want the status to change from…
-
Search Projects as Per RYG status
Hi, I looking for solution or moreover a formula to get a project name back as per RYG status. But i am getting problem, i have a same RYG for more then one projects. For example: i want a list of projects As RYG "RED", the selection has to show me 2 projects in retuen Project 1 Red Project 2 Green Project 3 Yellow Project…
-
Counting Check boxes when Checked
Hello, I would like to find a way for a way to count the check boxes when they are checked. Ideally, I would like formula that allows me to know what date it was checked. I'm not sure if the modified data column can do this because I do not have sufficient data at the moment. Another solution I'm thinking is possible is if…
-
Summarizing a Customer Satisfaction Survey that is ongoing with monthly reports
I have created a Customer Satisfaction Survey with 12 questions that use a 5 point Likert scale. (Strongly Agree / Agree / Neutral / Disagree / Strongly Disagree). I have tested the web page and it all populates the SmartSheet fine. Additionally, the first 5 questions are about the sales person, the second 5 are about the…