-
Background auto-refresh a sheet as frequently as every minute.
This might be my first real contribution to this community, but I think I have had a breakthrough with respect to background auto refreshing a sheet. I've seen the common solution of utilizing a workflow to trigger a daily update of a date column, but the challenge has always been that you are obviously limited in how…
-
Default values in Columns
Hello all. We have a Sheet and sometimes users forget to add important fields. We want to add default values to these fields in order to not be empty. The types of columns that need to have default values are: Text/Number, Contact List, Dropdown List. We have tried a way to add default values with workflows on Dropdown…
-
Countifs Reference Another Sheet - Help
This is the formula I am trying to use with reference to another sheet. Range 5 I want to only count if ticket status is "resolved" and Range 6 if in the month of Dec 2023. Error "Unparsable". =COUNTIFS({Field EDI Request Sheet Range 5}, [TICKET STATUS], "RESOLVED", [{Field EDI Request Sheet Range 6}, (LAST STATUS DATE},…
-
Need to identify the current month plus the last 7 days of the prior month
Hi there, I have a helper column that checks the "Current Month" check box if the date is within the current month: I used this formula: =IF(MONTH(Date@row) = MONTH(TODAY()), 1) The business is now asking to identify when a date is in the current month or in the last 7 days of the previous month. For example, this month…
-
REMOVE IF SLOT IS TAKE
Hello! Can we remove a time slot in the drop down on a specific date if it is taken. Below is an example. For example if someone Booked - Dec. 31, 2023 - 9:00AM - 9:20AM, can we automatically remove that from the drop down list since someone booked it? What are the ways?
-
How do I get my events (recurring) to show up once a week in calendar view without manual input?
Here is the sheet with the two meetings that occur once a week: I want them to populate once a week automatically without manual inputs and to show in calendar view every week:
-
"copy row to another sheet" - Sometimes row gets copied down at the bottom?
Hi, When there is a workflow to copy a row to another sheet, why does the copied row sometimes appear down at the bottom of the sheet, leaving ~50 completely empty rows in-between the last row or text? I know technically smartsheet must be sensing that the rows in-between are not empty, but does anyone know what causes…
-
Anyone else have this issue with forms and know how to resolve?
I am having a problem with forms submitting into a SmartSheet. I've built a simple SmartSheet with some IF commands that apply a score based on dropdown menu answers. I also created a report that shows a selection of columns based on a field being populated. When I submit a form built from the simple Smartsheet, nothing…
-
link between sheets
Hi! I'm working with two different sheets. The first one has all marketing activities (webinars, events, trade show, etc). The second one has all the marketing assets created (Ebook, social media cards, etc). I would like to link which assets can be used for which marketing activities. A marketing activity can use more…
