-
Flag by Last Modified Date Formula
Hi, I have a sheet for an event we are running and I want to flag any row that has been modified in the last 72 hours (3 days). Right now I have a flag column and a hidden modified date column. Any help with the formula please? Thank you! Jared
-
Formulas in Jira linked Sheets
Hi ! I'm trying to do the following: - I've created a Smartsheet that is linked to Jira. - to help me report on that, I want to add columns that are NOT mapped to Jira and to some calculation or add some information. After the first mapping, I can easily add these columns, but my issue is that every time a new Jira is…
-
Roundup causing error on reports
Hello, I added the new roundup formula to my sheet and this cause all of my reports that reference this column to show up as #unparseable only on the report. This shows as a value on the main sheet. To make this worse any other formula on this sheet shows up as #blocked until this is removed
-
COUNT IF formula
Hello, I've read through a couple of different examples, but I am not having any luck. I am looking to have the # Assets count total displayed in the highlighted parent row/cell based on the following criteria. If # assets cell below the parent is greater than 0 for the total count to display.
-
Average of project completion for current year
I'm trying to average the "%" column based on rows that are only in quarter 1 (Quarter Identifier = 1), and have a completion date that is the current year. I'm trying to make this sheet roll over year-after-year and am trying to stay away from specifying "2019". The formula I have currently is: =AVG(COLLECT([%]:[%],…
-
Importing\Uploading Information
I know you can create a sheet by importing a document into SmartSheet and having it auto-create around the information; however, how do you continue this? IE You take a sheet from Excel, that will continue to be used, and import it into SmartSheet, then you want to update the information in the SS later by just…
-
Formula for checking Parent Checkbox when ALL Child Check boxes are checked?
I'm trying to find a formula that can be placed in a parent check box cell, so that when ALL child checkboxes are filled in, the parent check box then becomes checked. I have multiple columns this is needed for, so ideally looking for a solution without having to create a number of other columns to draw calculations from.…
-
Automate RYG Balls based on % complete and start and end dates
I would like to have the RYG balls automatically adjust based on the percent complete and start and end date. For instance, if my task is set to start on 10/2/17 and end 10/13/17, if my % complete is less than 50% by midway between the two dates, to turn yellow. If my % complete is less than or equal to 90% by the end date…
-
COUNTIF based on a category
Hi I have a sheet which looks at another sheet and counts the number of instances of a string appear in that column based on a string in the current sheet and that works. I now want the sheet to look at the other sheet, carry out the COUNTIF, but also bring across the category entry from another column, so that i can use…
-
Formula Confusion!
We are trialling smartsheet and overall enjoying it so far however we have run into a bit of brick wall and any help would be appreciated! We have a main sheet with all our orders on it, using an older version to muck about with layout at set up at this stage hence the old haulage dates! Each order has details of the sizes…