I'm looking to pull a budget report that will help calculate the total of a cell if the criterion cell has multiple values. I have a formula that works in Excel, but doesn't seem to translate into Smartsheet. I think my issue is how to specify the correct value for the criterion. Does anyone know the best way to convert…
I can't seem to find a way to send a Sight as an attachment like you can with reports, is this possible? I need to be able to send sights on a regular basis. This feature would be so much better than having to take a screen shot and attaching it to an email.
Does anyone know if the web form functionality will incorporate a slide bar rating scale? This exists in Surveymonkey and my Marketing team still uses Surveymonkey regularly because of this feature vs SmartSheet web forms. thanks!
Hello, I'm wondering how I can sync a dropdown menu (Status Column) to another column (Percentage Complete). Ideally, this function would change the Percentage Complete column to 100% when the status is marked "complete." Thanks in advance for your help with this! - Mike
I use templates as my archive system. I want to share my template sheets with my supervisor, but I don't see a way to share templates. Can I? If not, it looks like I can move the sheets to a workspace to share. Should I build my archive in Workspaces instead of under templates?
How do you change the setting for the checkbox column? I want the whole task to be crossed out if the checkbox is checked as done. I copied this from an old Smartsheet account and that setting didn't carry over. Thank you!
Is there a way to access a web form on the android app? I can access the form on the desktop version and through the email link but I don't know if it's accessible on the app. Does any one know?
I am responsible for tracking my companies incoming inquires and quotes. Did we get back to everyone, quote them, did they accept or decline the quote?, etc. As part of that I sweated out the following formula, =IF(ISBLANK([Follow Up Date]98), IF((TODAY() - Created98) - 2 > 0, IF(OR([Quote Accepted]98, [Quote Rejected]98,…
Hi Is it possible to have some fields in the card view span several lanes? Thanks, Galit
is there any way to load an email address into a smartsheet cell and then send an email to that address simply by clicking on it?