-
If statement that takes a column value and if meets a criteria, subtracts a number
I have been trying for several days and could use some help. In the image example here, I need to set 'Final Quote' to be one of the following: A) If [Apply TCC] is checked, then take [Quote before TCC] value, subtract 200 from it, and put that answer in the [Final Quote] B) If Apply TCC is not checked, I just need the…
-
Count rows where ANY of the criteria are met.
I need to count all the rows in my sheet where any one of the three required columns are blank. I want a Sheet Summary formula that stores the result. Psuedo-code: CountIf Status is blank OR if Owner is blank OR if Department is blank For reasons I do not want to get into here 😁, I do NOT want to use a helper column for…
-
how to use COUNTIFS and OR together
Trying to create a formula to collect a number of specific rows added in a separate sheet in the last week, last 2 weeks, etc. I have a formula that works for getting the number for this week : =COUNTIFS({Week Number}, [Todays Week ]@row, {OT Student Code}, [Student Code]@row) but I'm having trouble getting it to work. I…
-
Does anyone know how to convert this SUMIF Formula and REF a date from another sheet
Hi, Were looking to take this active formula which is currently working and replace the date ranges from another sheet (Cross Sheet Reference) . Does anyone know if this is possible ? Because it is time consuming to replace the date range on each formula, we want to be able to edit the date range from another sheet.…
-
Ancestor and Checkbox Formula
Hello! I'm trying to write a formula that I just can't seem to get right. I've got a project with several ancestor levels that I'd like to report on. I'm close, but I just can't seem to get it. I've added a Parent Row helper column with a check box. I'd like the check box to equal True (checked) if the Primary Column is…
-
How do I change the formula in the Metadata sheet so that I can include data from two columns?
Hi Smartsheet Community I am trying to edit a donut chart that displays projects by Change Impact (High-Medium-Low) across all stages (Initiate, Plan, Implement, Close, Closed) - while excluding Closed projects. Currently my data is taken from the metadata sheet - which unfortunately doesn't include the distinction by…
-
Summary field = date selected from project plan
So I have a standard project plan with timeline / gantt chart. Start date = [Start] and end date = [Finish] I have several mini projects in my smartsheet so have used the level calculation to detect level = 0 for start of my mini projects with levels 1 onwards for the children tasks I have successfully written the formual…
-
#BOOLEAN Expected Duplicate Month checkbox formula assistance
Formula I am using =COUNTIFS({F & A Monthly Updates Range 2}, Department@row, {F & A Monthly Updates Range 3}, "3"). The problem I am facing is when submissions are made multiple times for a duplicative month. For example, the form has a system column to capture the date the submission on the sheet form was made. If I…
-
Count "Red" symbols in Sheet Summary
Hi all, New to Smartsheet and wondering how I get my sheet summary to count the number of "Red" symbols for status reporting. Understand that COUNTIF won't count symbols from what I have read. Does anyone have a way around this? Thanks in advance.
-
How can I make my calendar reflect the color of a data selection?
Hi! I am making a calendar that will include multiple locations that will then be put on our company webpage so all global employees can see what is going on at any other location. People from different offices will be able to fill out the form and it will auto update on the webpage. I have a dropdown with the different…
