-
Copy-paste an image into a field in a webform
Hi, I have a form for users to report bugs in software (and I'm sure I'm not alone in that!). Users should be able to copy-paste a screenshot directly into a regular field in the form, instead of having to save the image and then upload it. You can do this in the sheet itself (works a charm), but you can't do it in a form…
-
Counting the amount of cells above the average
Hi community, I want to make a formula that counts the amount of times a value is above the average and starts again when the amount drops below the average. Data is added over time and needs to be included to manage the overall trend. I have a master sheet with different conditions and I need to implement this for each…
-
As an Admin I can't add columns but can do conditional formatting and formula column conversion
Hello everyone, My boss gave me Admin permissions on a sheet in order to amend some columns. I noticed that as an Admin I can have access to some Admin functionalities (like converting a cell to a formula column or amending the conditional formatting) that were precluded to me as an Editor, but I am not able to add columns…
-
Having trouble with a workflow
Hi! I am having trouble getting my automation to function properly and need some help troubleshooting. I have 2 sheets, A and B. I have one automation that sends a copy of a line from Sheet A to Sheet B based on a drop down selection. This works fine. I tried to set an automation on sheet B that impacts the same line…
-
Inserting Column Not Working - for Pro User and Admin
I'm just became a paid Pro user (separate individual monthly account). A co-worker has an account and created several sheets which have been used for years. A new sheet was created, and they made me an Admin for the sheet. When I click dots in column header, and select Insert Column Left, I can enter a column name, and…
-
How do criterion ranges work?
I'm trying to use the SUMIFS formula to count the value of jobs in a certain year worth less than $25,000, but the part of the formula I don't understand is the "criterion_range" part because I'm used to just putting in a range and then a criterion, how does this work? My current formula (that doesn't work) looks like…
-
What is the best way to publish or share my public facing dashboard?
So my dashboard will be displayed on an ipad to visitors and will act as a dashboard to see total amount of visitors and has an attached sign in/out sheet. I want the ipads to be locked into thse screens becuase that is all they will be used for. Is it best to do this by going through the smartsheets app or by going…
-
I need automate the workflow
I have created 3 project plans called Project plan 1, project plan 2 and project plan 3. I also have created a form with 4 fields, Event name, description, event type with 3 values (Webinar, Offline, and Dinner), and Event date. Can you give me the detailed steps I should follow using smartsheets automation to have the…
-
Any limitations to number of sheets/ sheet filters?
Hi, I have "Enterprise" level account, and would like to know, if there is any limit to -Number of sheets that can be created? -Number of filters that can be created in a single sheet? -Number of dynamic views that can be created from a single sheet? Thanks in advance!
-
Update Requests: Alter system actions
Hello, The picture below shows an action to Go to Sheet as well as Open request. Is there a way to eliminate the Go To Sheet command? Thank you in advance for your help. Cathy
