-
Auto- fill information from another smartsheet
How can I make my smartsheet pull columns of information from another sheet? The data I want to have duplicated is entered first on a vendor intake sheet, the two columns I want to 'link' or duplicate are a unique name and contract number (in separate columns) and I want to have them pre-populate on a contract deliverables…
-
How do you have a cell in one Smartsheet repeat information to a cell in another Smartsheet?
I work with dates for campaigns a lot. I have multiple Smartsheets tracking different pieces of campaigns and the dates those pieces will launch. Is there a way for me to link the date cell in one Smartsheet to a date cell in another Smartsheet - so if I change the date in one Sheet it would change the date on the other…
-
business rule on 'Expected delivery date'
Hi, In my smartsheet i need to set a rule like whoever fillit out the 'Expected delivery date' should show three days later from the current date. Like lets say I am filling out on 1-May-2024 , the 'Expected delivery date' should show 4-May-2024. The use should not able to choose any date before 4th may. IS it possibe
-
Risk flag when past due date and task not started / no due date set
Hello! I'm very new to formulas, I would love if someone could please point me in the right direction - I'm trying to get the flag to turn red when a planned finish date is in the past AND the status is either in progress or not started. But I don't want it to flag if it's not started and there isn't a planned finish date…
-
Report another column value when a max is found
Hello, attached is the sheet im working with. I'd like to report the location name of which has the max value of minutes. What function do I use to do this?
-
How can I add an index-collect formula using parent / child relationships?
Hi everyone, I'm looking for some help with a parent / child formula. I've got a primary column that lists a project name (parent), with labor resources nested underneath (children). I also have two date columns in the same sheet - start date and end date. Both of these columns auto-populate with an index(collect formula,…
-
Create new rows in Sheet2 as soon as a column is updated in Sheet1
Hi Team, I am facing a unique problem and unable to find a direct solve for it. Seeking help from the forum here. I have a sheet [lets say Sheet1], with 30 columns, out of which there is a multi-select dropdown column [say 'Impacted_Countries' with all countries listed]. When the row is initially created, this column will…
-
Subtraction formula that is based on another formula
Hi everyone, Please send help. I have a formula set up to calculate total costs. However, I need to have it set up so that the total amount subtracts from a budget total. For example, say the budget it 20,000. I need the =SUM(Amount:Amount) to automatically subtract from the 20,000. I hope this makes sense. Thank you!
-
Count unique values from a separate sheet
Hello, SmartSheet newbie here with my first question for the community. We were able to build a working formula to count unique tickets in original sheet =COUNT(DISTINCT([Ticket #]:[Ticket #])) I then took the above formula to my metrics sheet and changed to reference another sheet value and the formula no longer worked…
-
How can I find the Unicode for a gray circle so I may use it with the UNICHAR function
I'd like to expand my RYG list to include gray in addition to red, yellow, green and blue. But how do I find the code so that I can use it with =UNICHAR(XXXX)? My current formula is: =IF(COUNTIFS(CHILDREN(), "Red") > 1, "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Yellow") > 1, "Yellow",…