-
Archiving Design Pattern in Smartsheet
Hello, We currently have a very large Smartsheet we use to collaborate with external business partners. I have created workflows to add rows each week, and our cross-functional teams complete tasks related to each of these rows over a period of weeks. We are struggling to find the best way to declutter this sheet once all…
-
Formula to show text next to sum amount
Good day, Our Currency ( BHD for Bahrain Kingdom ) is not one of listed currencies and I wish to show it to amount numbers , how to have Currency BHD seen next tp total sum in below formula ? =SUM([Service Charge]4:[Service Charge]13) Also , is there a way or formula to show text ( BHD ) or any other text next to number…
-
IF/AND, OR
Hi All, Smartsheet newbie here 👋 trying to figure out what seems to be a basic formula with no luck... I would like my "At Risk" column flag to get checked if the "Due" column date is past today OR if the "At Risk" dropdown is selected on the "Status" column. Here's my started formula that doesn't include the OR:…
-
Project Health formula Help needed
=IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", IF(TODAY(10) >= [End Date]@row, IF([% Complete]@row < 0.75, "Yellow", "Green")))) These is what I want the rules around the health to be but when i enter the above formula the cell is blank some of the time. If scheduled end date is…
-
Formula - Completed projects in a given year
Hello, The formula pasted below works great if I want to count the number of projects completed in a year. How can I revise the formula so that I can count the number of projects completed in 2020? Thanks!
-
Automating Status of "Completed"
I want to be able to have all tasks with a status of "completed" moved to the bottom of my parent section. I don't want to move to another sheet, but instead to the bottom of the parent. Is there a way to do this? Formula / Automation? Thanks in advance! -mc
-
% complete using checkboxes
Is there a formula or function that will count up the # of children checked off and report the total % checked in the parent row? As an example, I have two out of six activities (children) checked off, which means the parent work package is 33.33% complete. I would like the parent checkbox to report the 33.33% and update…
-
Use of "If-Formulas" in Smartsheet-Salesforce connector
Hi Smartsheet Community, we have the Smartsheet-Salesforce Connector in place and for a new connection we need to us "if-formulas" within the connector settings. Example 1: If a date field is empty in a project in Salesforce, would like to put date 12/31/2999 (and not an empty field) in the corresponding field in…
-
Populating a daily Schedule when there is a range for a task
Hey all - I'm hoping someone can jump in and help us with a formula that will look at all the dates in the range and help us pull the information into another sheet when any of the dates in the range are the lookup. This is our master scheduling sheet which shows a box scheduled for pouring Mar8-Mar17...so 8 production…
-
Populate Dropdown
Is it possible to populate a dropdown field with values from a column in a sheet using a formula? thanks! Adam