Discussion List
Message: Your Smartsheet session is no longer active
I'm getting this message "Your Smartsheet session is no longer active" - which I don't mind - however, I'm getting it after I start typing or updating data. I get the message, the sheet reloads and added data is lost. It's happening in a variety of sheets, not just one. It's been happening for a few weeks. Is anyone else…
Freezing top row OR colour the header row
Am I able to freeze row 1 on a sheet so when people fill out the form, the data imports underneath row one? OR Can I change the colours of the header row like I have with row 1?
Freezing Top Rows
Is there a way to "Freeze" the top row? In our time sheet this top row is a sum of all the hours entered for the week. Users would like to be able to see the sum as they scroll down to projects to enter time. TIA! Julie
Sorting Parent rows but not child rows
Is it possible to sort just the Parent rows but not the child rows? Our parent rows need to be sorted in alpha order however our child rows are in order of task and we don't want them to be sorted.
Calendar creation
I'm trying to create a calendar so that everybody in the office knows when the jobs are scheduled. How might I go about doing that?
Countif - Not!
All, I may have gone next Lv here but the following basic counts results in 0. I've written first 2 then tried the new AI feature to confirm and same result, 0 count.. ? Ultimately I want to count how many orders Dale took in 2024 to current date Sales Rep column is a drop down with up to 9 reps no multiples. Date of order…
How to get help
We are in the process of upgrading our app but need help, sent a couple of emails to devrel@smartsheet.com, no response. Is there a phone number or any other way to reach developer support
How to copy and replace data using automation
Background: I have a sheet with a list of projects and their monthly savings actuals+forecast (Jan thru Dec) and prior forecast (Jan thru Dec) where prior forecast is last month's actuals plus forecast. Between the 1st and 10th of every month, project owners will go in and update actuals for the previous month and forecast…
Calculate Number of Deals on a Waitlist at a Given Time?
Hi, For context, a buyer and seller will approach my team and provide us with a proposed close date of their deal. Often times our deal teams are finishing up other deals and cannot immediately start working with them. We create a Salesforce opportunity and add them to our "Waitlist" (category in SF opp). Sometimes this…
Formula issue
Hi Brain Trust We have a formula set up to report when two columns don't have the same drop-downs selected. =IF([Candidate Compliance & Training Check]@row = [Job Compliance & Training Requirements]@row, "Low", "High") The team now want to use the following symbols What or how can I set up a formula that will give me :-…