-
How do I write this formula?
I want to write a formula that calculates the number of days we have from today until we run out of stock. I have: The number of Laptops Available The Avg Monthly Hires and I know we give out laptops at NEO every other Monday (Next one in February 17, then March 3rd, March 17th so on) How can we tell the number of days…
-
Gantt Timescale Settings Global Option
Problem: Our project has stakeholders who use free accounts and utilise the Gantt view. They can’t edit the view settings so it currently opens for them in 2023 (start date of project) and also does not show the year so it can cause confusion and annoyance. Solution: It would be great to have an option, in the Gantt…
-
Microsoft Loop Integration for Dashboards
Hello! I have been building out the back and front ends of our business unit's portfolio. One of the requirement was an easy space for our Directors to leverage in order to run their meetings. We leverage Loop in our business to take meeting notes and to share out follow up tasks. I would love to have the team's loop live…
-
Form date field settings
On SmartSheet forms is there a capability to set a timeframe for the default date used in a date field, rather than using an exact date? For example, we'd like to set it for something like "10 days in future" so that the default date field would always be a future date that would align with our standard lead times. Right…
-
Title format to include H1 for accessibility (Headers start at H2)
Utilizing Wave to confirm accessibility. Title at top of form should be formatted as H1 so that assistive screen readers recognize as a title, pre-heading. We hope this is a simple html fix that would help many users.
-
Needing to edit webpage of a Smartsheet
Hi I have a smartsheet that seems to be attached to an external webpage where external staff are able to enter information that goes directly into my SMartsheet, while not having access to teh SMartsheet itself. How do I edit this webpage? I have made changes to the Smartsheet fields and this is not updating on the webpage…
-
SUMIF
Hi Everyone, I think this is a very basic question. I want to graph the total piece rate items completed (Daily Totals) for a drop-down selection of (Job Codes). I have the sheet up and running and know how to create a Dashboard with graphs etc but just need help with the formula. Thanks in advance
-
Countif with Has formula
This discussion was created from comments split from: How to count answers in a dropdown column.
-
Return All Values based on a Filter
Hi, I have a file with two columns "Process Name" & "Process Type". I would like to do a unique filter like in Excel. Return all Process Names where Process Type = 3P - Third Party. While not user friendly, I was able to get this to work for the unique values, but cannot figure out the filter: Row 1:…
-
Automate "User List" report
It would be great to automate "User List" report to be sent to an inbox on a cadence. Thank you!
