-
Column descriptions for Reports
Does anyone know if this has been submitted for enhancements, or if this option is coming in the near future?
-
How can I create drop downs with selections based on a previous column?
For a product management file, I want drop-downs to be limited based on how a previous column is filled out, as it would be a massive dropdown list otherwise. For example, if "fruit" is selected in the "food type" column, I want the next "sub-type" column to have a drop down list for apples, bananas, grapes, oranges, etc.…
-
Countif formula for time
Hi all, I am trying to find a formula to count the number of times a time appears that is over 30 minutes. The times are all listed in Column 21 in the following format: 0:15, 0:27, 0:13, 0:20 I have tried using variations of the below formula but I get error messages. =COUNTIF([Column21]:[Column21], >=0.30) Anyone have an…
-
Moving Average
Greetings Is it possible to plot simple moving average on Smartsheet ? Thank you
-
Restrict access to smartsheet webform
Hi, I'm setting up a smartsheet webform and I only want certain users only to be able to access the form itself. Is there any waay to set up user controls to only allow specified users with access to submit information to the webform? Thanks!
-
Reports not showing data from Sheet in cells.
I have two Sheets; one for a project’s status on all services, and another Sheet for all the details of the project, with “Project Name” linked in both sheets. I go to make a report for one of the services, which pulls data from both sheets (or SHOULD at least). In the Report Builder, I choose the two sheets in the…
-
Set a flag 90 days before due date and after due date
I am trying to flag contracts needing renewals. What am I doing wrong? =IF(OR([Contract end date]1 <= Today1 + 1 - 90, 1, 0))
-
Column Limits vs Data on a Single Row
TLDNR (short version) GOAL – everything in reports / sheets to be on one row per project PROBLEM – I run out of columns and reports won’t merge data from multiple sheets to one row. (long version) Typical spreadsheets can present as one project row and all it’s details in columns to the right (scrolling is left to right)…
-
Deciding what rows go on my calendar view
I have done this before but can't get it to work this time. In fact, in my current sheet. However, I can't remember how! I have a checkbox column called SHOW IN CALENDAR. I want the check box to determine what shows in the calendar view. Did I create a separate filter with this before? I just want what I want to show in…
-
Report Building Criteria
I am trying to build reports that segment my data into 5 different reports. One for each year 2019, 2020, 2021, 2022, and 2023. When I select the GLY (Go Live Year) with any on the aforementioned years, my reports come back blank. However, when I select a different criteria and then add the GLY as an additional column, the…
