-
Unparseable error being returned
I am not finding the error in my formula, Client is a text field and Start and end dates are Date fields. Any help would be greatly appreciated Regards Michelle =IF(AND([Client]1= "In Progress", [End Date]1 < TODAY()), "Moderate", IF(And([Client]1 = "In Progress",[End Date]1 = > TODAY()), "Mild",IF(And([Client]1= "Not…
-
Upcoming Release - Whats In It?
There is a new release coming. Yay! We were all just summarily notified of the upcoming release and the expected downtime. Any chance we can get a list of proposed changes included in the release? And please don't send me to the roadmap page with the generic message on releases and a copy of the release notes from the…
-
Card view settings
Is there any way I can view the cards showing only the columns with data from the grid view? For example i have about 20 columns on the grid view, and i would like a rule so that when i look in card view only the populated cells appear.
-
Error Message on Sub Tasks
Hi I created a bunch of sub-tasks and when I tag people in the comments and they get the email, when they click on "open in smartsheets", they get this error: "This card is not visible in card view because it is empty" Any idea what is causing this? Thanks!
-
About Time Calculation
How can we calculate time between start date and finish date? I want to know by hour and minute format?
-
Formula to check Child Row checkbox if Parent row contains "ABC Dept" (filtering by Department)
I have a "Master" project resource sheet with great grandparent rows for "Current Projects" and "Future Projects", Then grandparent rows for each "Project", parent rows for department and child rows for the individual resources per department. I'm trying to create a filter to filter resources by department across…
-
Formula for taking an average of duplicate rows
I'm attempting to construct a formula for taking averages of multiple ratings from several raters across three vendors. Sheet 1 looks like: Rater - Category - Vendor A Rating - Vendor B Rating - Vendor C Rating Sheet 2 looks like: Category - Vendor A Rating Avg - Vendor B Rating Avg - Vendor C Rating Avg On sheet two, I…
-
Must start / must end date restrictions
Dear community I'm a Project Manager in the field of business administration. I'm a former MsProject user. I'm very happy using Smart Sheet. It's great and I would recommend to use it. However as Project Manager for projects within the administration environment I do have a desperate need Smart Sheet does not cover. It…
-
Auto Populate second sheet
Hi, I have a main sheet with a form. As you know, every time a user submits a form, a new row appears. I was wondering if there is any way to have a separate sheet that connects to the main sheet so when a new entry is added through the form on the main sheet, a column is updated on the second sheet reflecting the new…
-
Filter not Working: Is not in the last (days)
Hello, I'm drawing a blank on why this filter is not working correctly. I process the archive of the data in this log and will archive every week the items that are 21 days or older. This is how I have my archive set up and it always returns items that were submitted today (which most certainly does not meet my filter…
