Marketing
Discussion List
-
Adding to InventoryIn Formulas and FunctionsI'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…
-
FORMULA NOT WORKINGIn Formulas and FunctionsHI, 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 …
-
Dashboard Widget Chart Issue with Multi SelectIn Formulas and FunctionsI 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 somethi…
-
Method to limit attachment types?In Using SmartsheetI 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 …
-
Proofing Review RequestIn Using SmartsheetHello, 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…
-
Countifs project status is neither complete nor cancelledIn Formulas and FunctionsI'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 hav…
-
How to include double quotes in the output of a text formulaIn Formulas and FunctionsI 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 + ", " + SubmitterFirstNam…
-
Automatic item numberingIn Archived 2015 PostsIt would be really good to be able to format text entries so that they are numbered automatically based on indentation level like: 1. Header 2. Header 2.1. sub header 2.2. sub header 2.2.1 sub sub header 3. header I actually wonder …
-
Re: Task AlertsIn Archived 2017 PostsI am wanting to use smartsheet alerts to email me each day with tasks that are due and not completed. However they don't always come through each day despite it having the right set up To do this I use a form to add new tasks and then inc…
-
Proofing Full ScreenIn Using SmartsheetWhen you initially send out a proof in Smartsheet you get a button to "Review Proof" which sends you to a full screen mode to review the image. However, whenever you got back to review that proof for that row it only opens it up…