Discussion List
Edit fields directly in 'View Summary' in Dynamic View vs. using Details Panel
It would be much more efficient in Dynamic view for editing fields if you could just click into the field and edit it right there instead of having to click on the field, wait for the Details Panel to open, then scroll through the list of options and enter the data into the details panel. From an administrator point of…
MAXIF, MINIF, AVGIF Formula Capability
It would help to have the IFS functionality and combined statistical functionality MAXIF, MINIF, AVGIF, MAXIFS, MINIFS, AVGIFS similar to the current SUMIF and COUNTIF. IFS can shorten multiple nested IF statements and easier to formulate, read and understand when referencing multiple conditions. The combined statistical…
Freeze columns in a report on a dashboard
If a column is frozen on a report and that report is used in a dashboard, it would be helpful for that freeze to apply when viewing the report on a dashboard.
Can you Customize a Date Format to be Month and Year only?
I need to make a column that only allows users to enter the Month and Year, without including the Day. This is meant to provide a general idea of when something might happen. Can someone explain how to customize the Date format to only show Month and Year? I've seen an option for Month and Day, but not for Month and Year.
Best way to capture data from the field
Attached is a picture of a daily report form that we capture from each crew on a daily basis. These are done on paper and handed in weekly. Looking into how we can utilize smartsheets to get this information on a daily basis and digitized. My first thought was to create a form to gather all this info, I soon realized I…
How do I freeze columns in a report on a dashboard?
I'm trying to include a report on a dashboard, but I can't seem to figure out a way to freeze columns when the report is on the dashboard. Is there a way to do this? Any suggestions are greatly appreciated.
Looking for Employee Training and Development Specialist - Internal Systems
This discussion was created from comments split from: 🚨 New Community Topic: Community Job Board.
How to Calculate Age from a Specific Date & Average Results
I am trying to average the age of multiple events as of specific dates (end of each month). Currently I have "Age" calculated from "Today()" in a column in another sheet. I would like to instead calculate the Age from "Date of Notification" to "End Date", and would like to avoid using a helper column to do so. I do not…
Cell links vs Index/Match
I understand they basically provide the same functionality but I was wondering if using cell links (Datamesh) vs Index/Match had the greater cross sheet reference performance effect when loading a sheet
How to create an automated update request for assigned tasks based on job roll
Sorry if this question has already been answered but I am having a hard time clarifying what I am looking for to search. I have a sheet of employees with a helper column (called structure) that is displays their job title as a number using descendants (lower the number the higher their position). If needed this can be…
