-
Can you filter a sheet to view entries between two times the days prior?
I am looking to filter a sheet to show only entries made between 6AM yesterday and 6AM the day before yesterday. I tried using a helper column with the below formula to input a value that I could then use in a sheet filter to show only those rows with a value of "1" but am getting an error in return. =IF(Created@row <…
-
Uploading multiple contacts for Dynamic View
Hi, I had to manually load 200+ email addresses for Dynamic view. Can that be fixed so I can simply add a comma separated email list? Thanks,
-
Regio date settings in Attachments
Hi, Just noticed that the screen where attachments are found, the date stamp is in jibberish USB -sorry I mean USA- style ;) Anyway to fix this? My region settings are set for sane people. So I would guess that should be in order, except it's not :/
-
Unhide specific columns on a sheet
Instead of unhiding all columns to find one or two that are needed, it'd be great to be able to unhide specific ones, like Excel does with Tabs.
-
Hidden Columns List
I would love to have a collapsable/expandable list of all hidden columns on a sheet with the option to unhide them from the list. This way, if I have multiple hidden columns and I just want one or two of them, I don't have to unhide everything to get to them. This would also allow you to look for columns that might be…
-
Join us for the New York City Smartsheet Summit!
📣 Calling all project managers and portfolio directors! 📣 We are excited to invite you to join us at the New York City Smartsheet Summit on Thursday, Dec. 5! This partial-day event will be packed with valuable insights, networking, and hands-on opportunities to enhance your project and portfolio management skills. 📅 Date &…
-
Formulas
Is there a way I can calculate on a metric sheet the number of Sites completed within the last 3 months?
-
Why does my INDEX(MATCH()) column formula return #NO MATCH for some values?
I have a simple formula (below) that references another sheet matching the value @row on the destination sheet. This is a column formula in the [P6Description] column. =INDEX({Source Sheet - Description}, MATCH([P6Number]@row, {Source Sheet - Project Number})) Why am I getting #NO MATCH for the project numbers starting…
-
Add the attachment URL to a column for a row to be listed in the JIRA description.
I am using a formula to grab different columns data for a row to be used to create the JIRA description for a ticket. I need to be able to have the attachment URL for a row to be listed in the JIRA description as well as part of the formula when the ticket is created.
-
Recall AI Prompt at a Later Date
Absolutely love the AI companion. However, after a formula is generated, I lose access to the prompt that was used to write the formula. If at a later date, I want to come back and alter my prompt, have to completely re-write it, risking error due to human memory lapse, especially if the prompt is long and the resulting…
