-
Date column formatting
Hi! In regional settings, I can change the default date format for a particular region. I'm not able to find anywhere to change the default manually other than creating another column with a formula. For example, I'd like to just have the date show month/day. Is there a place to do that? Thanks, Richard
-
Does anyone have any great manufacturing process systems
I am always looking for some ways to improve our sheets and the overall system. i run a manufacturing company and I am looking for anyone who is will to share their flow in smartsheet. We do a rebuild every year and do a planning week to refresh our processes. It is time to do this so any shared ideas would be great.
-
Need to Resize Window Linked Through Dashboard
I have a shortcuts widget on my dashboard. This contains links to Smartsheet items as well as other useful links. When a user clicks on the link, the linked window appears but it cannot be resized. As an example, I have a link to a project sheet. The sheet comes up using a small portion of the screen, with the Windows…
-
Checklist for Airbnb Cleaners
Hi all! I want to create a checklist for the cleaners who turn over my airbnb properties. I know how to create this checklist but there are a few specific things that I need it to do and can't figure out how. Any advice would be appreciated! 1) This checklist will need to be filled out each clean. That means there needs to…
-
SUMIFS Statement under Parent Item
I need to Sum the "Total" column cells IF: 1) Column Department Allocation Code = "49 CONTINUOUS IMPROVEMENT: Formula: =SUMIFS(Total:Total, Department Allocation Code:Department Allocation Code, ="49 CONTINUOUS IMPROVEMENT", Item:Item, =PARENT(Item1)) *Not working <img alt="" data-entity-type="" data-entity-uuid=""…
-
Form help - one field per row??
Is there no way for multiple small fields to appear on the same line? I'm wracking my head for what feels like a simple issue... Building an entry form and want a section to look something like (ease of use). Field A [_____________________] Field B Field C [________] [_______] -instead of- Field A [_____________________]…
-
Smartsheet export to excel corruption error
My team has been exporting a Smartsheet to Excel for over a year now then 5/30 we started getting a corrpuption error on our export to Excel (see attached Corruption1 & 2 Attachments). Trying to firgure out why this is happening now. I submitted a help ticket to Smartsheets however they miss read and assumed i was trying…
-
Parent Date Roll ups - Possible for two sets of dates?
I have a head scratcher here, thanks in advance for any help that anyone may have. My scenario is this, I have project plans that have two sets of dates, one is estimated dates and the other is the actual dates on the project tasks. In my project settings the estimated dates are linked to the dependencies. When I enter in…
-
Sheet scrolling with mouse issue
Hi, I am unable to sheet scroll using my mouse. Pulling the side tag works but not with mouse since today. Any reason for this? Rgds Ian
-
Coverpage for Tempaltes
has anyone come up with a creative way to combine a template with a cover letter? So example - we use smartsheet to gather requirements, we want to deliver those requirements to our customer at the end of the project in a polished package. Right now, we use the export to PDF, and add a few notes in the provided comments…