-
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…
-
I need a formula to return the last, non-blank value in a row
My formula is: =JOIN(COLLECT([Week 1]2:[Week 52]2, NOT(ISBLANK([Week 1]2:[Week 52]2))), "LAST") This formula returns an "Incorrect argument set" error. What am I missing? Thanks, Tony
-
Custom Colors for Sheets
While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional…
-
View access to sheets and Dynamic Views without creating Smartsheet account
We would like to share our sheets and/or dynamic views of our sheets with our customers without them needing to log in to view. This should be offered in the same way that Microsoft and Google allow their customers to give view only access with a URL. The Publish option does not work for us because we have set filters that…
-
Formula to sum a column from a 2nd sheet with 1:many match across 2 sheets
Hello, I am stumped with a cross-sheet formula. I tried the AI tool but only received links to articles on cross-sheet linking, so I'm reaching out to the community for a life line. This is what I am trying to calculate: Sum [Est. Cost] from sheet: {Construction Estimates Details} only if the values in [Task Name] column…
