-
Using formulas to copy, or transfer data between cells.
Hello community! I am looking for a seemingly easy solution which I can't find. While the workflow automation helps in many ways, the "actions" available seem to be greatly lacking. For example in google sheets + scripts + triggers, I can have a cell update based on a formula from a time driven event (whether external or…
-
Cannot log in to iOS app on iPad
I get the attached error when attempting to use my email address to log in to the iOS app on an iPad via my work SmartSheet account. I have no trouble using it to log in via browser either on the iPad (accessed my account in both Chrome and Firefox) or on my PC. Please advise and thanks in advance!
-
Power BI
Hello, When a sheet is updated in Smartsheet will a report in Power BI automatically read that update? Without having to wait a day to refresh or having to reload to Power BI online, etc. Thanks!
-
Automated export and Automatic upload
Each time a row is added (which is requiring an approval) i need the sheet to export the new data, to either an excel spreadsheet or google doc and upload to a secure site. The other option would be to do this based on frequency like nightly, but I guess the real question for me, and yes I am both new and green here, can…
-
Make Collapse ALL default
I have clients with indented children. Everytime I come to the sheet the children are fully expanded. How do I make Collapse ALL the default setting? Matters not if I save it as collapsed.
-
Replacing form attachments
Hi everyone, I am creating a system in which students submit a form for a project that they are presenting to the university. The system calls for constant feedback and re-submitting. The only problem is, I don't see a way to automatically remove their previous file and replace it completely with their new file. This is…
-
Can I Auto Assign Tasks to Myself?
When creating a new task can I have it automatically assign it to myself?
-
Updates via webform
I have a business rule list in SharePoint. When updates are needed, the change management process is managed in SS. Currently, the user has to tell us the ID number and name of the business rule manually. Lots of room for error. We would like to be able to pull the ID number from a drop down which then allows the data to…
-
How do I give an outside user access to ONE row of a spreadsheet?
Here is the deal. I run a wedding video studio. I just made a smartsheet questionnaire (form) to have all of our videographers answer from the smartsheet app on their phones at the end of the shoot to inform the editors of anything they need to know about, etc. One of the questions asks them to upload photos they took from…
-
Showing Only the Parent Rows in a Dashboard Chart
Hi - I have created a dashboard to show pie charts of my data. My problem is that the pie chart wants to include every single row as a data point, I only want to show the parent rows and not the children. I used the formula "=Count(Ancestors(row))". This gives me a 0,1,or 2 based on how many ancestors the row has. But I'm…
