-
Sum of values across Arrays/Lists
Hi there, I have a column that shows a set of values like this: COLUMN A Row 1 20:40:0:0:20:0 Row 2 2:4:0:0:0:4 Row 3 . 0:0:0:0:0:0 etc. Each row represents a project task. The value represents the number of employees needed for the task across 6 different employee types/categories (categories separated by ":"). I need a…
-
Formula Improvement
Hello! I am trying to write a formula to count whether a group is active or inactive and how many groups are active. There are a couple conditions though, column1: the cell must not be blank (if it blank, it should not count), column2 **is a dropdown menu with three choices** : the cell must either be blank or contain…
-
Formula to track % complete of a fabircation component in a row
Good evening, I will try and explain this without messing up * We are using smartsheet to track fabrication of product * each row is an item we fabricate * each item has a budgeted amount of time per task designated in a column * they are python, fit up , weld, unload, and admin * the sum of alloted time is *…
-
Using Collect() Function to Summarize Data by Project and Date
I have two sheets, one where I had a form that lets people input safety scores a row at a time for a given construction job site and another where I'm looking to summarize all the safety scores for a particular job site overall, today, this week, etc. I can get the overall safety score for a particular job site:…
-
Convert months to years
Hi, I have a sheet that currently takes a start date and adds a number of years from another column to create an end date: =IF(OR(ISBLANK([Contract Start Date]60)), "", IF(OR(ISBLANK([Contract Period (Years)]60)), "", DATE(YEAR([Contract Start Date]60) + [Contract Period (Years)]60, MONTH([Contract Start Date]60 - 1),…
-
Dashboard Chart Displaying Currency for Viewer
Hi Smartsheet community, As an Admin, I setup a dashboard with a chart showing data with $ signs. A viewer sees the same dashboard chart with US$ signs. Is there a way for the viewer to see only $? Thanks for any suggestions! Dee
-
Return a cell value based on multiple variables
I am having trouble working out a formula to put into a cell. I want the cell to change, based on the value in a cell. If the 'status' cell in my document is marked as 'complete', I want to change a cell at the end of the document to 'Complete'. If the status cell is marked with anything else other than 'Complete', I want…
-
Prioritize Order of Record Fulfillment
I have a list of records in a worksheet, and would like for each of them to be prioritized 1 through ### (depending upon how many are in the list). Each record needs to have a unique priority, because the order in which the record will be acted upon by an Owner will be determined by where it is ranked in the…
-
If And Formula Help
Greetings! I am new to the forum so I apologize if my question is redundant! I am trying to combine two "If" statements into a single formula. I need smartsheet to look at two columns (Due Date) and (Project Completed -- checkbox) and determine if a project is late. I can get each half of the formula to work individually,…
-
Calculating Totals
Dear all I deal with importing goods from all over the world, and payment usually happens in multiple currencies. In smartsheet, I have a column for currency (USD/Euro etc) and the next column I have the amount. What I am looking for is a payable total in each currency, E.G. For Payable euro, the formula will look at all…