Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for November 2017
Discussion List
Date Formula
I am having trouble converting this excel formula =TEXT(C7,"mmm-yyyy") to the Smart sheets equivalent. Can someone help me?
Formula to create a Symbol response based upon a text string in the Comment
I am attaching from my emails a specific email response to the comments. The email will always have the same email the address is from. I would like to create a column using a symbol and say..... If the following text string is listed in any comment related to that record and to show a green dot.
Mirror Smartsheets
Hi all, I am trying to find a way to mirror a certain area from one smartsheet to another. The problem I am facing is that some cells are locked and I couldn't find a way to automatically create rows and columns in the sheet it it pointing out to. Does anybody here have an idea if there is a solution to that? Many thanks :)
Formula to get data from current week only by day of the week.
I have a worksheet with case information and who these cases are assigned to. I am trying to add columns that will total the cases from each day of the current week. ex. columns with a total count for mondays cases, tuesdays cases etc. thru friday. This worksheet has data for the whole month and all I need is the current…
Nested IF statement - with checkboxes
I am looking for an IF statement to check the box if true, but do not check the box if NOT true. =IF([Actual Response Date]47 <= [Response Due Date]47, 1, IF((ISBLANK[Actual Response Date]47), " ")) I have an Actual response date, so when the date is over the due date OR is blank, I do not want the checkbox to have a…
if statement
Hello, I am trying to make an "if statement" but I got no luck. I don't know how to start, I tried with =IF(sqf1 > "32", "width1*hight1*5.5", "sqf1 < "32""width1*hight1*8.5") I know its looks bad :D Thank you
Creating an Alert for Attachments
I'm using a Form to collect data that is populated in Smartsheet, and the form asks each user to include an attachment with their submission. I'd like to be able to mandate that the form cannot be submitted without an attachment OR set up an auto-notification to the user submitting the form to submit an attachment if that…
Sharing Reports without sharing sheets
We want to share reports with customers so they can see schedules but do not want customers to be able to view other customers schedules on the primary sheet. In order to share a report we must also share the primary sheet. Is there a work around for this?
Use query strings to populate a contact list dropdown value in a form
Is it possible to pre-populate a dropdown field in a form with a query string value when the values of the dropdown field are set to contact list and have a pre-defined set of people?
Outlook Online is stuck on Connecting to Office 365
After adding the app, while adding Smartsheets on Outlook Online I get stuck in Step 6. "In the add-in panel on Connect to Office 365." I click on Connect to Office365, click the user to sign-in (my only username) and get a constant thinking wheel. Any ideas?