-
Advanced Conditional Formatting Question
Hi Smartsheet Community! Does anyone know if Smartsheet has the capabilities to apply a conditional formatting rule, but the rule will grey out other rows based on the selection you made in the row where the rule is applied? For example, I'm working on an onboarding checklist at my company, and want to apply a rule to…
-
Were dependencies recently modified or changed?
In the past, using the Finish to Finish function, the dates I would see are as below: Line 1, 4w, 12/1/23 - 12/28/23 Line 2 (FF to Line 1), 1d, 12/28/23 - 12/28/23 Opening my project plans last week, I noticed that my dates for single day lines changed that anything FF with a duration 1d now span over TWO days. Line 1, 4w,…
-
Permanent Sorting Column Sheets
Please allow sorting to be permanent on a sheet. My Issue We log our trucking miles and have a sheet with current and previous miles columns along with other information. Those two columns pull from another sheet filled out from submitted forms. Our main sheet will reference the most recent miles submitted and the previous…
-
Multiple actions on status complete workflow
I want to take multiple actions when status of a task goes to Complete. I want to capture the status date I want to Lock the row from further updates I want to copy the row to another sheet (capture all tasks that completed) I created 2 separate workflows to do these actions, and they appear to be working. #2&3 are…
-
Formula Help - Counting Multiples as 1
Hello - Need some help figuring out the correct formula to use for what I need. I've put a sample data table below. Essentially, let's say I have a sheet of requests that I need to to track by category. 1 category may have several rows but I only need to count 1 for any of that category that have an unchecked box. See data…
-
automated sending of attachment
Hello Community, I have created PDF's from data gathered in a form. I want to send the PDFs back to the contact (a column in the sheet) but I don't want to send links to the sheet. Is there any way to do this in automation. I realize it can be done manually. Thank you, PeterL
-
How can I validate contact names I have pasted into grid sheet?
Hello I am a user of Smartsheet and Resource Management for Smartsheet. I have these linked together to allow resources allocations in SS to be shown in RMS. However I have an issue. I want to put leave in as a project, but I need to paste leave information into an SS plan. I can do this but the pasted names are not…
-
Move/Copy rows between sheets
Hi, I'm using move rows action to archive completed task from one sheet to another archive sheet. All works just fine. In the archive sheet I'm adding more columns, related to the archive. Now I got request to send some selected rows back from the Archive to the original source sheet. Is there any way to select which…
-
Add comment Action
Hi everybody, I really like the automation option in the Smartsheet. I wonder, if there are any options which will allow to post a new comment? It will be very handy to be able to update the comments even with included reference to selected person from selected sheet column.
-
@Mentions
Hello! I've been having some trouble with the @mention feature on my Smartsheet. In all the other smartsheets that I have used, when you type the @ a list of emails begins to populate, and for some reason my Smartsheet doesn't do this, which makes it really hard to mention someone whose email you don't know. My…
