-
Parent Row Symbols based on highest priority?
It is possible to create a formula that will change the symbol to represent the HIGHEST level out of the 4 rows? IF the (HIGHEST) Risk Level for rows 1-4 is "x" THEN action for symbol column is "low" = blue symbol is "medium" = green symbol is "high" = yellow symbol is "extreme" = red symbol I currently have a formula to…
-
Count the number of projects in a folder
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…
-
Count Number of Children Cells that are not blank.
I'm having difficulty with this one. I have a parent row of "Rental Lead" I would like to count the number of child cells in column "Training Course" under the parent "Rental Lead"
-
Multiple linking
I'm looking to select a row based off of 2 criteria searched for in the row, and return a third value in the same row. I feel like this is possible with the existing functions but for the life of me I can't seem to figure it out. This wouldn't be difficult with array equations in excel but i'm not having any luck…
-
Sheet Summary
I have a sheet that I created as a log essentially. What I'm wanting to do is create a "report" that summarizes the data. As an example, I want to report total records, smallest number, largest number, and count of records with a specific condition. How would I go about doing this?
-
Date checkbox formula
Hello, I have a column of dates which are showing when an item expires. I want to have a column with a checkbox and a formula in it that will tick if the test date less 365 days is within the current month of todays date. So basically the test date less 365 days, and then checking if that date is within the current month…
-
Formula help
I'm trying to create a single sheet that has multiple audits from 4 facilities. I am finding problems in trying to have smartsheet count the amount of cycles in the audit. The information is being input through the web forms so new rows are being created constantly, and the information needs to run through the sort filter…
-
HELP - FORMULA - equal to AND IF/THEN
Final Decision (WEBFORM) is a hidden column with the webform results in Yes, No, Hold symbols I need a combination formula for "Final Decision" column: 1. To equal the results in "Final Decision WEBFORM" column 2. AND IF "Final Approval" Column is checked, then show "Yes"
-
DEPENDENCIES FORMULA IN TO A PROJET SHEET
HELLO; I HOPE YOU CAN HELP ME WITH THIS PROBLEM: I NEED TO SCRATCH A FORMULA TO GENERATE DEPENDENCIES AUTOMATICALLY IN A PROJECT SHEET WITH THOUSANDS OF ROWS. EACH ROW CORRESPONDS TO A TASK REPEATED RANDOMLY. AND MY PROJECT HAS MORE THAN 70 DIFFERENT TASKS, SO IT IS VERY LABORIOUS TO ASSIGN DEPENDENCIES USING FILTERS BY…
-
Price Book Entry Import
Dear colleagues, I am seeking for advice on the following challenge. I am using Smartsheet to update and insert Salesforce Price Book Entries. Inserting a new entry requires Price Book ID and Product ID. If I map these fields, they are imported from SFDC and won't sync to a new entry record. Similarly, if I create new…