-
Trying to copy formulas from the Source Sheet to the target sheet using DataMesh
Hi, I've set up a configuration, that merges entries using copy from a source to a target sheet that is updated with the latest new rows. Copying of the data is working fine, however the formulas in the source sheet get lost in that process. Is there any way to avoid this? Background: I've an Excel sheet containing…
-
Using the OR and AND Function together
I have a checkbox that I need to have checked if the Due Date Field is less than today and the Status does not equal Completed or No Longer Required. I've tried multiple combinations of formulas and I have not been able to figure it out. I need some help. Here is the formula that I currently have. =IF(OR(AND([Due Date]15 <…
-
Percentage Formula
Has anyone built/used a formula to capture the percentage of specific responses in a series of questions? We're experimenting with Smartsheet Forms to be able to administer an exam. Each column would be a single-select dropdown of the multiple-choice exam question format. On the backend, we want there to be a formula…
-
Status Colours - comparing dates
Hi Quite new to SS, but have been tasked with trying to update a current sheet to show a colour status column. I have 2 columns which hold dates, with some of the data been pulled in from other sheets, thats need comparing. If someone can help with the formula to show Green, amber, red status dots depending on the below…
-
Using a Relative Date in COUNTIFS Formula
I'm looking to use a relative date in my COUNTIFS formula (ex: In the next 7 days). This needs to be evergreen so I don't have to be updating the dates every day to have an accurate count so I need a relative date functionality rather than using a lesser than-greater than formula.
-
average(children()) not working when cell in child row is a calculated field
Hi, =Avg(Children()) not working when cell in child row is a calculated field as shown above. Is there anyway to fix this.
-
Parent status (RYGB ball) changing based on child status (dropdown)
I am looking for help with a formula where I have a parent row and then multiple children rows below. The Parent has an overall status that is a 4 ball symbol of red, yellow, green, blue) My child rows are using a dropdown menu called "Confidence" with percentages as the values (10%, 20%...100%). I'd like to set the the…
-
Help with DISTINCT Function
I need to create a list of unique names pulled from a column on a different sheet. I used this example to get things generally working. However, I'm not ending up with a truly unique set of names. The formula in question is: =JOIN(DISTINCT(COLLECT({Fruit}, {Fruit}, @cell <> "")), ",") + "," Here's an example of how my…
-
IF - THEN - IF/AND Formulation
Having a hard time with formula logic. The setup for a RYGB column: If the row is a parent row, I want it to do (X), where is as an elaborate string of calculations based on a another column's values If it isn't a parent row: AND IF it is complete, then I want a BLUE Harvey ball, else, a GREEN Harvey ball Can this be done?…
-
INDEX and MATCH help
Hello, I am building a dashboard to pull information off multiple sheets, and have created a separate "config" sheet to use formulas and organize the information to make widgets easier. I am looking to pull info from a date column in a project plan, based on a unique task name. I have a column in the config sheet that…