-
INDEX MATCH is overridden by new entries
Hello, I'm trying to create a formula that will identify the [Unit] in Sheet 1 that have confirmed [Today Entry] from Sheet 2. The issue is when a new entry comes through Sheet 2 where [Unit] matches it will override the previous INDEX MATCH action, removing the entry from the list of [Today Entry] in Sheet 1 even though…
-
Adding New Task After Setting Baseline
Smartsheet Community: Once The Baseline is Set. It Would Be Nice to Have The Ability to Add New Tasks and for those Tasks to be Added to The Baseline without Re-Setting it. Today, I have to Manual Change All the Dates. This Drastically Increase human Errors and is Very Time Consuming.
-
Approval tracing like update request
we are just able to trace an approval request on the column. there would be a list of approval requests like update requests. Also, would be better to manage those approval requests like cancellation, trigger from start again (we can use sequential approval requests in one automation) etc.
-
Option to Toggle off Admins Receiving Access Request Notifications
With the new update rolled out last month, all sheet/workspace Admins now receive access request notifications instead of just the Owner. This is causing major headaches for the large corporation I work for. We have thousands of users and many do need Admin permissions to perform their tasks in workspaces. However, they do…
-
extra blank page on my dashboard print to PDF
I opened a case with support, but they told me to try on firefox or portrait, however neither suggestions worked. I am trying to print a dashboard. I cant figure out where the heck the margin is and it keeps adding a blank page. I also tried consolidate blank spaces, but that didnt fix either.
-
How to remove characters from the right?
I'd like to remove characters from the right. What formula would I use? Example: Person's Name (FL) I want to remove the (FL) part and have the cell only reflect the person's name. Thank you!
-
Extract a Text String to remove unwanted text
I have 2 reports that I have to compare. In one report, I get the text string I need to compare, but with extra text appended to it. How can I use a RIGHT or LEFT to extract only the needed text when it is of variable length? Example textstring1don't want this textstringtextstring1don't want this The output I'm looking for…
-
Allow User to Expand the Text Box for Customize Messages in Automations
Please add the ability to expand the text box when writing text for a customized message that is part of an automation. In most software, this means an option to click on the bottom right corner of the box and drag it out to expand it. It is helpful to see the entire message when drafting it, and later when reviewing or…
-
Data Shuttle
I'm trying to use the offload function to add any new rows at the end of the night to an existing excel sheet in Box. I seen an option similar in the upload function, but is there a way to do this with Offload? I don't want to delete existing rows in the Box excel sheet, just add to it.
-
Automating Data Mapping in Smartsheet Forms Based on Date Matching
I am using Smartsheets as a daily tracker for my prayers. I am creating a form for this tracker. I have a pre-populated Date Column and then 5 prayers columns with dropdown column options of yes and no. The idea is that every day at a specific time (end of the day) I will fill out the form and update the tracker via this…
