-
Changing the date display format
Hi there, I'm aware that I can change how the date is displayed in my schedules by going into my personal settings and setting the relevant country (in my case, the UK), but I would like to adapt the display format further to show days of the week. Is this possible? Note: I'm using grid view. I'm aware I could switch to…
-
Shortcut link
Looking to create a summary smartsheet that has a list of sheet names in column A and shortcut links in column B. I know you can link cells within a sheet but i the desire is to link the entire sheet.
-
Release 2016-08-06 Comments user experience & bug?
If I hadn't been reading the doc* I likely would never have realized that feature existed. Now I know. When adding an attachment to an existing comment: 1. Click Edit Comment 2. Add Attachment via the icon. - Save button greyed out. - click Save button does nothing. 3. Cancel button closes the 'editor' but the attachment…
-
Is it possible to simple display the number of child cells that exist in a parent...like in the pare
Is it possible to simple display the number of child cells that exist in a parent...like in the parent will say Tasks ( 8) because they are 8 children
-
Add card to a specific project or task
hi, When in card view , how do i choose to which project is a new card assigned? When i click add card it doesnt give me an option to select project name. This way i have to go back to sheetview and rearange it again.I like to stay primarly in cardview . thanks for any help on
-
hide formula errors
Hello, I have WORKDAY formulas that are correct, but there is insufficient data to return a value in the formula cell so I'm getting an error. (There's no due date yet) What I would like is a way to simply hide those errors, but still have values appear when due dates are entered entered into the cells they reference to…
-
Subgroup within Drop Down List
Good Afternoon Everyone, Hoping someone has some tips for me. I am creating a smartsheet with a webform for our marketing department to help obtain and organize work order requests. On this web form, I have a dropdown list for the client to specify where the request is for (we have numerous hotels, retaurants, attractions,…
-
How can I write a formula to summarize in parent row summaries in child rows?
Column is entitled Status and is a drop down list with the following selections: Not Started In Progress Delayed Cancelled Complete I have a formula in each child row to summarize grandparent rows: ="Not Started (" + COUNTIF(CHILDREN(), "Not Started") + "), In Progress (" + COUNTIF(CHILDREN(), "In Progress") + "), Delayed…
-
Date created as start date in Calendar range
Hello, I'm trying to use the system generated creation date as a start date for a range in calendar view. For some reason it's not recognizing the column as a "date" column? Any ideas on how to make that work? Thanks. - Eric
-
Setting Non-Working Days based on Assigned to name
Hello, I have a rather odd question that I'm not sure if anyone else has dealt with. We have a project with team members located at different facilities around the globe. As a result, we have different holidays associated with the various regions (EU, USA, Asia Pacific, etc) that will impact the working days available for…
