-
Can a Smartsheet form use two levels of conditional logic?
Hello, I am wondering if a Smartsheet form can be modified to use two levels of logic. I'm not seeing how to make this work, but wanted to check. Logic desired: User selects a 'Lane of Business' option from a drop down Selecting any option from 'Lane of Business' forces the next question, 'High Level Support Needed' to…
-
Grouping data by month and sorting it chronological way in a row report
Hello everyone, I'm trying to create a report in which the data pulled in (in this case "submissions"), is grouped in months (i.e., 3 submissions in August, 5 in September, 2 in October, etc.) as to show which months are busier. The grouping and the sorting tools though, in their options "sort ascending" or "sort…
-
Conditional Formatting Behaving Unexpectedly
Hi, I have not been able to figure out what to change to get the conditional formatting in the sheet, per the second rule, to dynamically change as time passes and/or the status changes. The red font is not changing back to black when the End Date becomes in the past, and/or the status column is changed to Complete. Thanks…
-
Recipient not receiving workflow notifications
My workflow is not notifying all recipients. I can run the workflow, both manually and with the trigger, and receive the email notification as an Admin. He is the Owner but isn't receiving notifications. I checked his email contact; it is correct. He has NOT unsubscribed from the workflow. I'm perplexed. What else should I…
-
I can't change or copy a Sheet Name as an admin
Dear All: I am made an admin to Sheets that belong to someome else for different departments. I just noticed that I can copy and paste a Sheet name as an admin in some Sheets, but am unable to do the same with other Sheets. Are there ways for a Sheet owner to restrict that? I am mapping Sheets by using DataMesh for a major…
-
Form Submission Restriction based on date lead time
Hi there!! I am working with a form that we'd like to put a restriction on if a date selected is within a certain time frame. Example - We're putting in place a minimum of 7days lead time for requests to be satisfied and would like the form to be unsubmittable until that requirement is met. I don't see a way to do this…
-
Using an Automation to Duplicate a Row in the Same Sheet
I have read several posts that suggests that this is not currently an option. I have a sheet which contains a list of evaluations. Sometimes we have to complete a second, or even third evaluation of the same person. Each row represents a person and their evaluation. If we have to do a second evaluation then much of the…
-
Printing the gantt chart
Hello, Is there a way to print ONLY the gantt chart and not the columns? Thank you!
-
Why is my Excel exported from a report empty?
Hello, I am trying to solve an issue I am having with exporting data from a report to an Excel sheet. We have a financial report that is exported to Excel on a weekly basis. This week when our employee went to create an Excel export of this report, the excel had no data and only showed header names. I tried exporting this…
-
What is the Smartsheet cell limit?
What is the Smartsheet cell limit including all cells, empty or contain only formatting information? Is it 5million or 500k?I see one of the trusted site mentioned it as 5M.