-
Count, sum, average
I use Smartsheet to track employee certifications. I'd like to determine the average number of certifications per person at each site/area. I'm able to use an equation to determine the number of certifications each person has, but that occurs in each row which throws off the average. In other words, =IF(Status1 =…
-
Cell Linking for Updates?
I'm trying to find a solution to reduce the number of updates my team and I have to do. We currently use Smartsheet to create and manage project plans but also have a master "Status Sheet" that lists all projects, their current task, and the deadline of this task. Whenever we update the project plan, we also have to update…
-
Moving rows from one sheet to another
We use Smartsheet for our production schedule. The schedule consists of 9 sheets that are all in a workgroup. Is it possible to setup a rule that would allow a row from one sheet to be moved to another sheet using the checkbox feature? Thanks, Jim
-
Gantt View - % Complete Column
I've noticed that to have the "% complete" column value show up graphically within the Gantt display, the "% complete" column MUST be a free-form entry field. I have another sheet column that uses the "Progress Bar" type. I was hoping to make the "% complete" column calculated based on the value within the "Progress Bar"…
-
Autofill formulas from adding a new Card
I find the value of Smartsheets to be the card view. I almost exclusively work in card view, and routinely add new items by adding new cards. There are several fields that contain formulas. Until today, adding a new card seemed to add the row appropriately at the bottom of the sheet, inheriting formulas. However, i'm…
-
How to auto-refresh the datamesh vlookups?
Hi EVeryone- I have a sheet which contains the lookup values to my master sheet, and I have created a few datamesh lookup rules which works well, but if a new row gets added to my master sheet, I need to go to datamesh website and refresh the rules my self. Is there anyway I can automate this so everytime I dont have to go…
-
How Do I create a value based on a date or date range?
I have a due date column that I am trying to return a specific value from.My fiscal year runs from 10/1/17 through 9/30/18. Is there a formula that I can write that would pull the fiscal year and month and put that in a cell based on said due date? So if a due date is say 12/14/17, I would like it to say Dec FY18 in that…
-
Colouring Cells using a formula.
Good Day All: I would like a cell to change color (background color) based on a range(See Below). Has anyone used such a formula? My Sheet: https://app.smartsheet.com/b/publish?EQBCT=906e1a0d8f8342e4baead18e6d0a76e4 Overall Rating Score 4.6 - 5.0 (Green) 3.6 - 4.5 (Light Green) 2.6 - 3.5 (Yellow) 2.0 - 2.5 (Light Red) <2…
-
Lookup function in Countifs statement?
In my sheet I have a list of projects with various statuses and I need to do summary numbers by month and reduce the number of statuses to 2 (scheduled and unscheduled). I know how to do this if I use the Lookup function to populate a column with the converted statuses, then use Countifs to get the numbers for each month.…
-
Reminder for every month task
Hi, Every month, we also help our client (around 1000 ) to prepare monthly financial reports and upload their web site. Some of them has specific date required to upload. In SS, we have total 4 sheets. Each sheets represent 3 month(we can't put 4 sheets into one because limitation of SS:, maximum 5000 rows) . We have one…
