-
Need Formula Help Multiple Date Columns, count days, if blank choose other column
I have Multiple date columns for approvals. I want to find the number of days between columns, but some are blank so I need it to choose another date column based on what I set. I've included example data.
-
Is there a way to use a checkbox (or formula) to bypass a required form field or turn it off?
We have a contact information form that will be distributed quarterly so the respondents can provide contact info changes and updates within their organization to ensure that we always have up-to-date information. Most of the fields are required however, in the event that the respondent has no new changes or updates to…
-
Formula to calculate the average number of days between all dates in a range
I have tracking sheets that record "sent" and "executed" dates. I am attempting to set up Sheet Summaries to determine the average number of days between all "sent" and "executed" dates in the sheet. (I want to do this without adding an additional column and calculating averages for each row). It seems I need some type of…
-
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…