-
Disable sorting for users, but still allow data entry
We are having a problem where accidental sorting occurs on a sheet used by several users, and I am looking to only allow users to enter data into a cell, but protect the placement of columns and rows. In my research I can not see a way to do this, because it is my understanding that if a row is locked, no data can be…
-
Set up automated workflow to copy child rows to another sheet?
I have a sheet set up with parent rows for each month. I want to copy the child rows underneath the "July" parent row to another sheet using an automated workflow. What condition do I set if I want the rows under "July" to copy to the other sheet on the first of every month?
-
Attn: Popular templates with our Marketing Customers
Hello Marketers! As a former Smartsheet customer and avid user of the platform, I relied heavily on template sets and lived in the Solution Center. I just wanted to share a few of our newest Template Sets aimed at tackling some of the most common marketing processes: Campaign Management, Marketing Shared Services (i.e.…
-
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…