-
collapse the "Shared to" right panel on Browse view
I hate that the panel that shows who a workspace or asset is shared to is constantly visible in the "Browse" view. It takes up a lot of UI real estate, especially on smaller screens like a laptop. I would much rather be able to collapse/hide/resize that panel, and be able to see the full names of my assets!
-
Project Plan - Start/End Dates, % Complete and Duration columns not updating.
Happy Friday! Appreciate your feedback, please! Here's a pic from my Project plan (created from the PMO Template) showing the column titles and rows 1-6. Rows 3-6 are in the first phase of the project (under row 2, grey). These are the only completed tasks out of 39 for the entire project. the rest are not started. I'm…
-
Form with Submitted By entry option not showing up like a normal Contact in a cell
Hi everyone, Thank you for your time looking at this, I appreciate all the help and guidance I've received in this forum. Ok, here's my situation. I have an intake form and one of the entries is for the submitters name. The Field Setting is set to a Contact. After submitting the form, their name they typed in would appear…
-
Formula to count multiple cell values and their dates
I am looking for assistance in creating a formula that will allow me to isolate values in the Provider/Resources cell, the Type cell and count based on Visit Date. Below is the a snapshot of the sheet. As you can see, there are multiple names in the Provider/Resources column, as well as the Dept column. The first name in…
-
How to make my due date column continuous and with a specific time range in between dates
I am trying to make the due date column so that it enters a date for every 22 days. I want this to be an "endless" column in that it goes all the way down without having to be manually entered. Is there a way to set the due date column to calculate this automatically and fill out all of the rows under it?
-
New Window pop-up option
A recommendation I would like to make is adding a feature under widget behavior. When connecting a Smartsheet under widget behavior, it would be nice to have a check box or a toggle switch that asks if you would like a new window to pop-up whenever the widget is clicked. A new window pop-up is allowed if you copy and paste…
-
Need help to auto populate a formula to display a number
It is simply EYYWK## -YY= year (e.g., 24 for 2024) -WK=week (e.g. 15 for right now. The 15th week of the year) -##=sequential e.g., 3x E-runs have been created this week, so the last "Full# in the book is E241503
-
Why do two Smartsheet sheets show same dates differently despite confirming format and timezone?
I've noticed a discrepancy in the displayed dates between two Smartsheet sheets, despite having checked for common reasons like date format, timezone settings, and data entry errors. What other factors should I consider to troubleshoot this issue effectively?"
-
Automate Parent Status Rollup based on Descendants' statuses
Hi folks — has anyone figured out how to enable users to update statuses manually for child rows, and then have the parent rows’ status update automatically? There are multiple levels of hierarchy. For example, I have three statuses that a child row can be; In Progress, Not Started, Completed. I have figured out the…
-
Allow to send attachments without linking to the sheet and adding other Smartsheet details
For business use, the automated workflows to send automated email messages is wonderful. However, the emails that can be generated if you want to include an attachment from the sheet is unprofessional, messy, and confusing. I love the look of the emails when you send just the message. I wish I could send a message and…