-
Report Headings in Sights
Hi Team, I have a report in my Sight and for the life of me, cannot work out how to increase the size of the headings! I've looked for options in the original sheet, the report AND the sight, and cannot find a way to do it! Please help! Pic attached to show you what I'm talking about. Cheers,
-
Calculating Variances with Negative Numbers
How do I do this on Smartsheet? I have an Actuals and a Budgets column. I'd like to compare the 2. So for example, if you have a Budget of 100, and an Actual of 70, then the variance would be -30%. IFERROR((Actual-Target)/Target,0) is all good for positive numbers but I need to ensure it also works for negative numbers. In…
-
File links uploaded into Google form are garbled in Smartsheet
I have an existing Google form and one of the options is to attach files. When the form is submitted, the values I'm getting in Smartsheet are garbled, something like: "0B6fDccPdKcYeY0tlcjJnVTlMYWM,0B6fDccPdKcYeQi1Malg1YXVDMmM,0B6fDccPdKcYeZkIxVURBU3hjbWc" This column is supposed to be populated with Google Drive links.…
-
API Backup Python Project
Hello there, Currently I'm Trying to do a Python API to backup my company data on smartsheet. I know that there is a Java API but i want to put the script on aws so python is extremely recommended. I found some stuff like that : token = ' ' ss = smarsheet.Smartsheet(token) # I Would like to backup all the file with the…
-
Troubles with inputting a value for notification
I am creating a sheet to keep track of a budget process. I am curious why a notification does not get sent out when I input a value by typing it in when using the "is one of" condition? The notification only works when I already have 100% typed in the column somewhere, then I have to select it from the drop down box. Why…
-
Automated Email updates-- SUGGESTING MORE EFFICIENT FORMAT FOR COMMENTS
Hi All-- I LOVE SmartSheet but I really wish the AUTOMATED emails that are sent that include the COMMENTS section could be setup like the emails that can be sent from manually selecting the "send" function on a row; which places the message ON TOP of the row information. Said in a simpler fashion--PLEASE PUT THE COMMENTS…
-
Nesting if functions for blank cells
I'm trying to create a formula with the RYB balls that says if two date columns (Start and Completed) are blank, then the value should be a red ball. If there is a date in the start column but not in the completed column, then the value should be a yellow ball. If both columns have date, then the value should be a green…
-
Email cc - ENHANCEMENT REQUEST
When I'm sending emails to workspace team members, I tend to CC myself. It's maddening when an email is sent to a distribution list because it clutters my Outlook inbox with an email for every individual recipient. I'd much prefer to have a single email that lists all recipients in the TO field of an Outlook email. I still…
-
Working within saved filters (enhancement request?)
We have numerous saved filters for a rather large spreadsheet. When selecting a saved filter and further applying filter criteria, it automatically saves the added filters to the saved filter when clicking 'Apply.' My enhancement recommendation would be to add an additional button (Filter or OK or whatever) that allows you…
-
Simultaneous use of form by multiple users
I am using a form to collect sign up information at an event. We will have multiple computer stations set up with the form. I wanted to ensure that we won't run into any issues with simultaneous usage / submittal of the form by multiple users. Thanks!