-
Can you check / help with my IF, AND, NOT ISBLANK formula
Hi all, This is my first post :-) Hoping for some help with a long IF formula. I have sheet that has columns with dates in them Launch Date, then Nomination Deadline, then Survey Deadline - in that timeline, so there won't be a survey report deadline after a launch deadline. Sometimes these dates are not filled in. I am…
-
Recurring Cleaning Schedule Setup
I'm helping my Laboratory Department setup a Tracker for a Cleaning Schedule that has a variety of pieces of equipment that each have a different time range of when they need to be cleaned (from every 2 weeks to 6 months). I had it in my head that I could use Gannt functions to setup the varying Durations of each piece…
-
% Complete Based on Child Conditions Met
Smartsheet Community: I Need to Add to The Formula Below to Calculate % Complete Only if it is a Pass, Fail, or Not Applicable. =ROUND(IF(COUNTIF(DESCENDANTS(), 1) / COUNT(DESCENDANTS()) > 0, COUNTIF(DESCENDANTS(), 1) / COUNT(DESCENDANTS()), 0) * 100, 0) + "%" Below is a Screen Shot of what I am Trying to Accomplish. Thanks
-
CountIF scenario
Hi Team, I have a scenario listed below where have created 5 options under dropdown Have placed the score based on the expected outcome. Not all KPIs have month #4 applicable since these are confined to quarterly measure and not Trimester. Each Month met gives you 33% if applicable for a Q and 25% of for a Trimester based…
-
How to source a Drop Down list from a column in a Report?
I have a "PO Request" sheet where I want a drop down list of Vendors to be pulled in from an ever refreshing report of Approved Vendors. It seems incredible that this drop down has to be updated manually. Is this really true or is there a workaround?
-
Total % Complete for 4 columns
I think this formula should be easy but I am terrible with formulas. There are 4 columns, when there is a date = 25%, if there is no date =0% and the final column that will show total % complete for the 4 columns: Formula I have is: =SUM([LAN MIGRATION COMPLETE2]@rowDATE([LAN Migration Ready Actual]@row, 0.25) +…
-
Incorrect Arguement
Hi all, last ditch effort here to help me keep my sanity. I have a formula that is working in one sheet. I've copied the formula and updated the references (as needed) but the formula on the new sheet returns an #INCORRECT ARGUEMENT error. Original formula (that works) =IFERROR(IF(WEEKDAY(TODAY()) = 1, COUNTIFS({Activity…
-
Using App to Schedule Resource
I am using Smartsheet to create a calendar system for reservation of a shared resource. So far, I have not been able to find a way to add TIMES to Smartsheet so more than one person can schedule the same resource on the same day, during different time slots. Can you help? Furthermore, these resources are occasionally…
-
Need formula help.
I have the following formula: =IFERROR(IF([Date Complete]@row = [Due Date]@row, 0, IF([Date Complete]@row > [Due Date]@row, NETWORKDAYS([Due Date]@row, [Date Complete]@row) - 1, IF([Date Complete]@row < [Due Date]@row, NETWORKDAYS([Due Date]@row, [Date Complete]@row) + 1, ""))), "") How do I add a contingency for if the…
-
Can I copy rows based on a formula updating?
Hi All - I'm working on new process, and have everything working except one small (seemingly) problem. I have two sheets that talk to each other, and they work fine. In Sheet 1, I have a status field (drop down), and in Sheet 2 there is corresponding Status field. When Sheet 1's Status field gets changed, Sheet 2's Status…