-
Issue with Record Date automation.
Hi everyone, I’m hoping someone can help me with an issue I’ve been running into. When a user submits a form late in the evening — sometimes as early as 8:15 PM — the “Record a Date” automation occasionally logs the following day’s date instead of the actual submission date. Originally, I used =DATEONLY(Created@row ) to…
-
Conditional Formatting on Sheet and Row Level
Dear Smartsheet Development Team, I hope this message finds you well. I am writing to suggest an enhancement to the conditional formatting features in Smartsheet. As a frequent user of your platform, I have found that while Smartsheet offers robust functionalities, there are limitations in the conditional formatting…
-
formula to return what day of the week a date is?
in Excel this would be the formula =CHOOSE(WEEKDAY(A1),"Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat") Does not work in SS?
-
PMO Metadata is showing invalid after I removed 1st row of the project intake sheet
I made a mistake, The intake sheet had the same row listed twice, the main row and row 1, I deleted row 1 and now my project metadata is now broken. Help!!! Thanks
-
Can you have a bar graph widget, automatically update the source range
Hello, I was wondering if it was possible to have a bar graph widget update its source range update automatically? For example, I currently have a bar graph that shows data from April, May and June - the numbers within these do update as new data is added. When it's the end of September, the bar graph will need to show…
-
CLOSED 🧠Automations Team is Looking for Research Participants! 🧠
Hi Community members, Our Automations team is looking to better understand how you manage and make sense of the automation workflows behind your projects and processes. No preparation is needed — and if you're selected for a session, you’ll be compensated for your time. If you're interested, please fill out this form, and…
-
Scroll through attachment images
It would be great to scroll through attachments without having to open each one individually. Thanks
-
What's wong with this formula?
=COUNTIFS({Master Project List Range 1}, "2 - Construction", {Master Project List Range 2}, <= EOMONTH [Month]@row , 0, {Master Project List Range 3}, >= [Month]@row ) I can't understand why I'm still getting an error message that this formula is unparseable. I'm trying to create a table that counts how many projects are…
-
Using index/collect formula from another smartsheet
I am trying to use index/collect to enter an email address located in another sheet. Source Sheet is Database Macro_2025: Target Sheet is Delinquency Report: Using 75033 as the example from the Source Sheet. I need the email for the Accountant of Customer ID 75033 to be entered in the Finance Contact Column AND General…
-
My automations doesn't work
I have a few automation to notify someone when certain condition met, but it works during our testing phrase, then I deactivate them for almost a week and turned them back on, but now it doesn't work! I event duplicate it as a new workflow and delate the original automation I created, but they still didn't receive them!…