-
Removing the "Comments" tab from Reports
Hello, everyone! Automated Reports that export as an Excel file attachment come with the report on one worksheet tab and a second worksheet tab called "Comments." I don't need the "Comments" worksheet, but there is no setting to remove it. Can we add that as a setting?
-
Counting only unique value with multiple submissions
I am not quite sure how to get a formula to work with the following exercise: I use a form to collect data from reviewers, they may make multiple entries in order to answer all of the questions, so 1 row may have study ABC withan answer of 'Critical' for questions 1 & 3, later they will submit ABC and answer 'critical' for…
-
Group Multi-Select Dropdown and Multi-Select Contact Columns within Reports
It would be great if we had the option to group line items in a report by options selected in a dropdown column. Ex. If you are viewing projects within a global campaign and have "country" as a column with the fixed values for all the available countries. It would be nice to be able to run a report where you could group…
-
cant create folder
a error appears every time I try to create a new folder
-
Output of date formula not detected as date type in a grid
Hi, We have a grid where users type in dates. Sometimes, dates are hard coded values, but sometimes it is convenient using a formula to calculate the value. For instance, you might want to calculate the value as another column + 30 days. The problem I see is, we have those columns configured as dates, with the "restrict…
-
How to attach a OneDrive file
I am in the process of moving the business from dropbox to one drive. When I go to attach a OneDrive file it opens the OneDrive window and I can see all of my files. If I then go down and select the file I wish to attach to the row in Smartsheet there is no option to then link it through. Should I be seeing an extra button…
-
Approval Workflow with additional actions
I have an existing workflow that notifies a supervisor that a part request has been entered. The supervisor needs to approve the request. If approved, I'd like the supervisor to answer two additional questions (without) having to go into Smartsheet. Ideally they would be able to: Approved: Yes/No Is this related to a…
-
Chaining together IF statements
I would like to know if it is possible to chain together if statements using the & symbol, similar to Excel. e.g. =IF(Brand@row="","",Brand@row&" ")&IF(Model@row="","",Model@row&" ") I have used this method in Excel, but this doesn't work in Smartsheet. Is there a way to make this work?
-
How do I automatically add emails to a User Group from a form with automation?
I created a form that requires users to provide their email addresses in a Contact List field. This form feeds (source) into a Dynamic View, but I currently have to grant each user access to the view individually. To streamline this, I set up a user group, making it easier to add users. However, I want to automate this…
-
Lock single cell
It would be very useful to lock a single cell. I see it's been asked many times on the community but I did not find anyone submitted it as an idea
