-
Using Contact Lists within a Form
Can we use a contact list within a Form and allow multiple individuals to be selected like when working within the sheet itself?
-
Can't build an alert - formula-based email not acceptable
Hello community! Anyone have a work-around for this? Here's the situation: I’ve created a vlookup formula in my sheet to obtain an email address from another sheet, and then want to alert someone using the email address result from the formula. When I go to build the condition in the alert (for approval), the alert will…
-
Calendar App Filters
Within the sheet/report, I have a Contact List column that contains multiple contacts per cell. However, when the Contact List column is used as a filter within the Calendar App, these multiple contacts per cell are not broken out into single values. Is there a way to separate values within the Calendar App filter? Or does…
-
Copy and pasting from other sources - why is it so annoying
Example I am trying to add a new 'row' via card view, in the pop up edit form that appears, I then go to paste in some key data, such as an email address from an email, the person's name from an email. When I click click, the cells are empty, if i add a space after the pasted content, its ok. What gives?!
-
Change Gnatt Bar Label?
The name of the task appears to the RIGHT of the Gnatt Bar -- can it either go IN the bar or to the LEFT of the bar? TIA!
-
New Mobile GPS Location Reporting
Hi Everyone- we just received a notification regarding a new GPS locating feature for Smartsheet, which would be a game changer for us, potentially. Can't seem to find any specific information on it though. Would anyone know where I might find a tutorial or video?
-
Data Uploader
Hi, I developed a data uploader workflow in order to update a sheet with the information that is exported from another sheet. The way that I understood this tool is: depending on the settings that I will do, the target sheet should be updated with the information from the attachment file in the source sheet so if the…
-
Genius Level IF (?) Formula
Does such a formula exist to acheive the below? If I edit the Stock columns in Row 1, I want the Result columns to appear as Row 2 (i.e. data shifted to the left eliminating blank cells). I'm nearly there with this formula, but it's not quite correct. =IF([Stock1]1 <> "", [Stock1]1, IF([Stock2]1 <> "", [Stock2]1,…
-
Custom Text for Symbols
I am sure I have seen a Smartsheet trainer change the names of symbols but from what I can research, this remains a request unresolved for a number of users. This should be a simple thing without needing to apply formulas etc. Can anyone help?
-
Automate Export to Excel
I am looking at ways I can automate export a smartsheet to excel at regular frequencies. I tried using MS Flow, but the Smartsheet connector doesn't have an option to get to get the content. Any ideas?