-
sorting problem
My Smartsheet keeps resetting to a seemingly random sort order each time I save. I've manually resorted the sheet using two criteria (the main column--Author--then another column--Title) but when I save and refresh, the sheet resets again. What can cause this?
-
Rollup report missing rows
Can't figure this one out. Hoping someone can help. I have 6 sheets for various projects we are working on. Each sheet has at least one level of heirarchy and some have up to 3 (parent/child/grandchild?). I have used cell linking to create an "amalgamation" sheet that lists all of the projects with their related…
-
Absolute record references
Is there a convenient way to assign a fixed reference to a record that remains the same even if new rows are added or deleted anywhere above the record? Something like linking cells from another sheet, only within the same sheet, may work, too. I often want to refer to another record, but if the record number changes as…
-
Default view when opening a sheet?
Is there a way to set a default view when I open a sheet? If I only want some children rows displayed and others collapsed, can I set a specifc default layout that will open that way everytime I open the sheet? Thanks Ian
-
Misaligned column headers
How do i realign columns and columnn headers in a large sheet? They appear progressively more staggered across the page. Here is a shot of the page about half way across, Very confusing! Thanks, Ray.
-
today() function
I want to create a formula tht creates a Datestamp of when a checkbox is clicked. If I use the today() function the date will keep going up. Is there a way to lock a date to the day a checkbox is clicked? Thanks, Shaun
-
Can you create a form that will populate a specific row and column of a sheet?
I want to gather the status on specific projects by sending a form. I would like that status to populate a specific row/column of a sheet.
-
Dependencies
Hoping someone can help puzzle out a way to make this work! I'm trying to find a way to show the original estimate at the beginning of the project compared to the updated estimate based on how the project is going, without having to refer to the version history (so we can run alerts and formatting and such.) Essentially…
-
Convert Text to Number?
Is there a way in a Smartsheet column to convert a Text value into a Numeric value? For example, I have a column called "Duration", formatted as a "Text/Number" column type, and I have values in that column that are in the HH:MM:SS format, and look something like this: 00:15:00, 01:20:00, etc. I'm trying to add a few of…
-
Question about sheet notifications
Can you create sheet notifications for when an attachment is added to a row? I thought that you could add specifications to be notified when anything changes on a sheet. Does this not include attachments? Thanks!