-
Any way to update formula criteria with drag-fill
Hello, I have a sheet with around 3000 rows all of which have a date received and I am trying to count how many were received per week. Currently I have a helper column which has the week number (1-52) and have =COUNTIF([Week number]@Row, =1) which works but I am wondering how to then extend the formula to automatically…
-
Primary Columns in Grouped Reports: change label locations and move column
A report must use a sheet’s primary column and the primary column must be in the first report column. Labels for report groups are displayed in the report’s primary column, so if you don’t want to view the primary column in the report, or hide the primary column, then the groups’ labels will be hidden. If you copy the rows…
-
AI Tools Button Disappeared on Enterprise Plan
Hello Smartsheet Community, While I understand that Smartsheet rolled out AI tools for ALL accounts for a period of time that has now come to an end, Smartsheet's post (linked) says it should be available for Enterprise plans. I am on an Enterprise plan yet my AI tools button is not showing. Does anyone have an explanation…
-
Contact list in Smartsheet after importing data
I am running into an issue where I import a group of names assigned to a certain task in Smartsheet. The list of names comes from an excel spreadsheet as multiple agencies must provide their inputs and not all have Smartsheet access (the Smartsheet in question is only for my agency's use). Well after importing the updated…
-
Monthly Summary Report Without Daily Data
I have a report that I use to take daily numbers, and it will output a monthly summary. At this time reports are not optimized to be able to grab that data and just give me a monthly summary. I have no choice but to have that daily data in the report. I have over 26 different sets of numbers, so it fills up quickly and I…
-
How to set up an automation that is based on an if statement?
Hello! I am trying to set up an automation that changes a cell to "Complete - Pass" when four different conditions are meet. The way I am doing this is by adding and additional column that does a pretty complex if statement, and from that it either returns "Pass" or "Fail". =IF([QA Filter FAIL]@row = "Fail", "Fail",…
-
Integration into Streamlit?
I'm looking to pull data from Smartsheet into a private Streamlit web app for a small team of people to edit data and make notes. Is this feasible? Is it as simple as just connecting the API to push and pull data?
-
Merged: Sheet Banners
This discussion has been merged.
-
Freeze Column issue
Good afternoon, We have a Freeze set to maintain the view of a certain columns that are referred to throughout the day. However, the freeze doesn't actually work as expected, as almost every time I go into our sheet the pane has been moved either direction which defeats the purpose of keeping certain columns visible at all…
-
[UPDATED] Community email notifications and saving important posts
Unsubscribe or Manage Community Email Notifications In the upper-right corner of the Community, click your Profile > Account & Privacy Settings Choose Notification Preferences from the options on the right. You can subscribe to any of your Followed Topics to receive notifications for every new post in the online Community!…