-
Reference main table to populate a new subset table based on conditions
Hi, I created a workspace that contains a list of project folders (and its respective sheets, reports and dashboards). I'm looking to produce a new consolidated Master sheet based on multiple criteria from each main reference sheet found in the workspace. In the simplified example attached, the new master table must be…
-
IF / OR formula help
Hi community, hope somebody may be able to help. I am trying to link a % of completion column with a progress bar. Formula is as follows: =IF([% complete]1 = "0", "Empty", IF(OR([% complete]1 > "0", [% complete]1 <= "0.25"), "Quarter", IF(OR([% complete]1 > "0.25", [% complete]1 <= "0.5"), "Half", IF(OR([% complete]1 >…
-
ISBLANK formula within IF formula
I am wondering how to incorporate an ISBLANK or any other solution into the below IF formula to overcome the issue I am having. The issue is that if Date 82 is blank, then it is automatically giving "Operational" instead of continuing the evaluation of the IF statement. There are no dates entered in either Date 82 or Date…
-
Flag By Issue Status Formlua
This seems so basic, but I cant get this formula to work. I have a flag colum that I want the flag to be 'flagged' if the Issue status column has an issue listed as "Open" This is what I'm using and getting an unparseable =IF(Issue@row = Open, 1,0) Thanks in advance!
-
Calender based on a report
I want to run a report that pulls data from several different project schedules and tie them together into a overall calendar. Is there anyway to add formatting to a report or to have a sheet mirror the information that is run on the port? I need to either A: Be able to format the calendar on the report(I know that reports…
-
Changing Status to a number in order to chart
Hello! I am needing to make a widget in a dashboard t show the number of "complete, not started, or in progress" items I have. I know I need to change the status to a number. I have tried to do this with "IF logic but am failing. Can someone help with a formula for the following case? If status is Not Started = 1 If status…
-
'Receive Copy of Form via Email' Checkbox: Default to Checked?
Good morning and hoping for help on a quick question, re: the feature to include a 'Receive a Copy of Your Submission via Email' checkbox at the end of a form. My team and I are designing forms to gather information from our end users, and would like to use a 'Receive a Copy' checkbox at the end of each form, to enable…
-
Returning Task Name based on a minimum number in Helper that is >0
I have previously asked a similar question, but with fewer requirements. I am trying to return the Task Name associated with the lowest number in a helper column that is >0. With some help from L@123, I was able to get close, I think, except the following code returns a zero, and there are no zeros in CHILDREN([Task…
-
why does smartsheets not Sum Cells with leading zero values
I am trying to do a =SUMIF into a sheet via cross reference (=SUMIF({Mth/Yr}, ={Prev Yr Mth/Yr}, {DofC NN.NN})) Mth/Yr = 9-2019 Prev Yr Mth/Yr = 9/2019 DofC NN.NN contains rows that have a value with 0.nn (nn = 01 thru 99) The result from the SUMIF is 0 (zero) Does SS not add values with leading zeros? What am I doing…
-
Is it possible to apply Conditional Formatting with a formula?
In Excel we have the ability to use custom formula for conditional formatting, is this possible in SS? Please see screenshot below. I need to compare column values to the value at the top cell. I can do this by adding more columns and formulas and then hide them, it would be cleaner if I can do with conditional formatting.…
