-
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!
-
Offset Columns Issue
Has anyone else had this problem before? If so what's the solution?
-
Row auto-deletes contents after a few seconds when I click on it
Hi, Whenever I click on a row it auto-deletes its contents after a few seconds and "asks" me to type in new content. This is incredibly annoying and I haven't been able to figure out a way to prevent this from happening - can anyone help? Thanks, Seb