-
Did you miss our “Ask Me Anything” with marketing expert- Dan Bloom?
Thanks to all who joined us for our "Ask Me Anything" session with Dan Bloom! We had a lot of great questions and look forward to hosting more of these sessions in the coming months! Missed the session? Please read the below to get some additional information about Dan Bloom and head over to our Marketing Group to view…
-
Network and share the #CanDo spirit with fellow marketers in the Marketing Group!
Our new marketing community group is live! Connect and collaborate with your fellow marketers, get your questions answered, gain access to marketing-specific content and events, and share your marketing expertise and know-how. To learn more, head on over to the Smartsheet Community Marketing Group.
-
Adding to Inventory
I'm sure this is simple, but I've searched for a while and haven't found anything similar! I have a sheet set up to track each piece of marketing collateral. It starts w/ the beginning quantity (say 100 pieces) and deducts the number of pieces that have been requested (through a SS form on another sheet), then another…
-
FORMULA NOT WORKING
HI, I have a formula =IF(E3>0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE can anyone help fix this issue?? Please see attached excel with formula in Column D Thank you in advance :)
-
Dashboard Widget Chart Issue with Multi Select
I have a dashboard chart widget that was pulling data from a single select option. I've now changed it to multi-select but I see that my chart isn't pulling in that item at all when there are more than 1 item selected. Am I missing something? Is there a formula that I can use to pull in that single option + any combination…
-
Method to limit attachment types?
I have a form that is designed for employees to submit news stories for our website to which they are also allowed to upload an image to accompany the story. My problem is that, despite specific instructions NOT to do so, employees often provide their images embedded in Word docs, PPTX files, PDFs, even ZIPs. I need them…
-
Proofing Review Request
Hello, I am starting to test out the new Proofing functionality and was wondering if there are permission level limitations on who can send out the "Set up Review Request"? We have some people who are admins and some who are not who would use proofing. I want to make sure anyone can send out a review request, but wasn't…
-
Countifs project status is neither complete nor cancelled
I'm new to this, and I'm having issues with counting the number of projects where Project Type = X and Project Status does Not equal Complete or Cancelled. I'm fumbling my way through unsuccessfully. This will go on a dashboard where I have other working formulas, but this is out of my expertise. Here's what I have so far.…
-
How to include double quotes in the output of a text formula
I am trying to combine several text elements into an image attribution for each row on my sheet. Here's my formula: ="American Society for Microbiology " + Category1 + ". " + Title1 + ", " + SubmitterFirstName1 + " " + SubmitterLastName1 + IF(ISBLANK([Co-creator #1, Name]1), "", ", " + [Co-creator #1, Name]1) +…
