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"…
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 …
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 …
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…
Formulas and Functions37skarkhoff
I want to use smartsheet as an international project management tool. One thing is driving me creasy.
I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario.…
Formulas and Functions251Alexander Wirtz
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 …
Formulas and Functions129Anna Mullins
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 somethi…
Formulas and Functions144Samira
I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true?
API & Developers361katherinehall
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 …
Using Smartsheet25Dan Snodgrass
So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use.
It has many application & the proof of concept exists and we use it.
We use it for an approval process (for in…
API & Developers1142JeremiahHorstick
Can anyone tell me if the Docusign Integration is Bidrectional or not?
Present users with a Docusign form which ask them to read a waiver and enter three pieces of information:
And then sign the form.…
Premium Apps and Integrations40Mary_A
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…
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 hav…
Formulas and Functions87Brian Lynch
I am trying to calculate the actual duration starting from a list of Start and End dates.
What I am trying to achieve is to exclude duration overlaps in order to get the actual effort days only, but including not contiguous…
Formulas and Functions65Alessandro Terranova
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 + ", " + SubmitterFirstNam…
Formulas and Functions130klontok
It would be really good to be able to format text entries so that they are numbered automatically based on indentation level like:
2.1. sub header
2.2. sub header
2.2.1 sub sub header
I actually wonder …
Archived 2015 Posts927Morten Høgholm Pedersen
I 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…
Archived 2017 Posts45Ben W
When 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…
Hi, this is my first time posting. Hopefully this is not a duplicate of another posting.
I just ran into a problem this morning with "What you see is what you get" is not consistent in exporting a document. I have a roll-up doc…
I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
Formulas and Functions65KDub618
I have recurring expenses monthly and it would be cool if I could have a new entry appear every month. Is there a way to do this? Thanks!
Using Smartsheet35Bret Linford
I have a job tracker designed to track the art components of our jobs. We would like to have a column display the next nearest due date for that row. My trouble is we may have 1-10 due dates on a given row and there are non-date columns be…
Formulas and Functions46DaveyJones13
I currently use reports tied to a central tracker to report out project updates to several different teams. Some of these projects require sharing of attachments and conversations about those attachments using the row's conversation tool. …
I created a basic project sheet and have been filling in tasks for two main deliverables (both shown as parent rows). Under those two parent rows are several child rows. However, the % Complete column is only auto-calculating for one of th…
My team is looking to add a team travel calendar to MS Teams. I'd like to keep the MS Teams tab in the calendar view. What's the best way to easily get the calendar updated with team travel plans staying in calendar view?
I was hoping I could get some help here.
So I've decided to create a status for each of the tasks my employee is working on.
There is a checkbox column for each category…
Formulas and Functions24Kristina Howes
I'd like to do the following
IF([Done]@row=1,"Complete),IF([Target Date]@row<14, "On Deck",<leave unchanged>)
Is the whole concept of leave unchanged an option?
Because I'd like to keep the default tha…
Using Smartsheet25Kristina Howes