-
Assigned tasks show as uncategorized when filtering by "Assigned To"
When filtering the timeline view by "assigned to", all but two assignees' tasks show up as uncategorized even though there are people assigned. In the screenshot, you can see in the left-most column that this is "Assigned To: Uncategorized" but in the pane on the right, it is Assigned To Chuck. How do I fix this?
-
Alt Enter causing copy&paste errors in and out of smartsheet
I've been coming across an issue in smartsheet (and in the Gov version) where some cells with a carriage return (alt + enter) do not copy and paste correctly into excel/sheets or vice versa from those platforms back into smartsheet. Exporting is fine but there are times I only need to paste a row into smartsheet from…
-
How to move lines so that they are together after filtered
Hello! I created an automation so that all the rows other than rows with column X's value = Y. Now, all the lines are apart from each other because a lot of the rows have been deleted in between. Is there a command line or something in automation that brings all these rows together so that they are right below each other?…
-
Why is the Report Builder Icon not showing? Just a refresh button.
Hi, I'm new to Smartsheet. I'm trying to edit the columns in my report, but report builder is not showing. All I see is a refresh button. I've included an image below.
-
Google calendar like option or work around?
Hey I have 2 columns that show different dates that I would want to see together in the calendar view. Has anyone figured out a work around for this or a clever formula to make this work? Hypothetically, for example: I would like to see the Packaging Release Date, Photography Shoot Date, and Copy due date.
-
Automation Emails
Hello! I've made a sheet that's associated with a form that has automation programed. With each instance of the following, the automation is to send an email to the identified personnel New Line item (New form submission) Edits to a single field During the testing phase, both rules worked and sent out emails as planned.…
-
Workflow with Condition Path
How do I set up my workflow condition path if I have the following situation: Employee 1 (E1) should be notified of the workflow approval if his name is selected in a cell, C1. If E1 does not respond today, Employee 2 (E2) should then be notified to complete the workflow action (E1's name is still selected in C1).…
-
Why would my workflow not be sending the notification
Hello, I am using the current workflow, but for some reason it is not sending the email notifications out. I have run tests to send to myself, but still do not get the email notification. I have checked the junk mailbox, but something is not working. I have other similar workflows that seem to work ok. This is just sending…
-
Showing Contact Names instead of email addresses in Contact Column in Sheet
This discussion was created from comments split from: How to show Contact Names instead of email addresses in Contact Column in Sheet?.
-
OR( ) for multiple criterion ranges within INDEX/COLLECT/SUMIFS
Hello, any tips for using OR for multiple criterion ranges? The formula below outputs #INVALID DATA TYPE. =INDEX(COLLECT({Task Name}, {Details}, <>"", OR({X Budget}, {Y Budget}), <>""), [Expense #]@row) The goal is to only pull tasks into the new sheet that have a value for either budget type (X, Y).
