-
Booking System in Smartsheets Forms
Hello everyone, I'm a relatively new user to Smartsheets and this is my first post. I have a question please about Smartsheets forms. I work as a videographer and I'm trying to write a form that allows people to hire out equipment (say for the sake of argument we only have one equipment type at the moment at that is…
-
I'm trying the CONTAINS and HAS formula and neither seem to work
I'm trying to count the number of times a word appears within a column range on another sheet; however, the cells I'm referencing have a dropdown so there may be more than 1 value per cell. I may be entering the formula wrong or not entering the right formula.
-
Conditional formatting
Hello, How can I write the formula to show that if the date in column A goes past todays date, hightlight the cell in red? Is that possible?
-
New user here... Need formula on how to count how many entries in a column are in a specific month
Hey there, I have wracked my brain for hours trying to find a formula that will allow me to count how many cells contain the month Jan, Feb, etc. So far I have tried the following.. Please let me know how I should adjust: =COUNTIFS({[ Range 1]}, @cell >= DATE(2024, 1, 1), {Certificate of Destruction Range 1}), @cell…
-
Formula help for previous month
I have a helper column for a report that I want to check the box if the DATE cell is in the previous month. Any help is appreciated!!
-
My Dashboard is Not Publishing
I am on the Pro Plan but when I try to publish my dashboard it says I need to upgrade. When I click upgrade it brings me to the plan I am already subscribed to. I am just trying to get a link to share to the dashboard. Any thoughts?
-
Formatting Options of Gantt
Is there any way to format the Gantt portion of my view/print? I need to adjust (narrow) the width of the Gantt columns so my chart fits on one page. Also, it would be great to be able to adjust the direction of the column titles (Jan, Feb, etc.) to display vertically, so I can narrow the columns quite a bit. I would also…
-
Automate dashboard?
Dear SmartSheet Community, I hope this message finds you well. I'm reaching out to inquire about SmartSheet's capabilities for automating the creation of weekly and monthly reports. Our objective is to streamline our workflow by eliminating the need for manual report generation. We are particularly interested in:…
-
Jira Connector subscription
I'm trying to reach out to sales or support team to subscribe to Jira Connector and resource management, but unfortunately with no response and cannot find from where I can subscribe with direct link, knowing that I'm subscribed to business plan
-
How can I track when a ticket is past its number of SLA days??
Hello, thank you in advance with helping with this question! Please see below: Situation: My team uses a Smartsheet intake form to take work requests from other teams. This populates into a sheet with the needed information to move tickets to different status' (ex: New Request, Active, Backlog, Triage Required). All of…
