-
Nesting IF Statements to provide % Complete
Hello All, I have a project sheet with the following status dropdown: Not Started In Progress Ready for Review Complete Canceled On Hold Not Applicable I'd like to write a nested IF statement to provide a value in a percent complete column. I've tried the following but get a #UNPARSEABLE response. =IF(Status@row = "Not…
-
Help with creating Formula's using " Is Blank" and "If"
So, for the first part of the equation, I wanna say " if the contract end date is blank, then the decision date cell will be blank" and the second part of the equation is the decision date column = (Contract End date minus Notice Period) =IF(ISBLANK(Contract End Date@row),COUNTIF([Contract End Date]@row - [Renewal Alert…
-
Using the average and standard dev formula
I am trying to use an average formula to get the average of data from the past 30 days. I tried using collect but seem not to be working as it gives me an error. I also am using standard dev formula both for the past 30 days/data before that row. Please help.
-
COUNTIFS help for future dates
I wanted to create summary tasks for items that are past due and then items that are upcoming in the next 30 days. My Past Due formula is working correctly: =COUNTIFS([End Date]:[End Date], <TODAY(), [% Complete]:[% Complete], <0.1) My Upcoming tasks formula is not: =COUNTIFS([Start Date]:[Start Date], <=TODAY(+30), [%…
-
Workflow for Tracking Inventory Counts and Bin Locations
Hi, I am trying to setup a sheet to keep track of when we count bin locations in our warehouse and how often. I would like every bin to be counted at least once ever 12 weeks. In our bin locations column, I have a multi-checkbox setup with all 403 of our bin locations in it. We typically count 5-12 bins a day. Can I setup…
-
Workaround for Voting
Hello, From other community questions I see that there is no voting functionality in Smartsheet but I am looking for a workaround. The use case is to have a system for internal enhancement requests to our ERP. Internal employees would have a link to a dashboard where they could look at requests that have already been…
-
I need help with At Risk Formula
I am trying to have the at risk flag appear when the following conditions apply: Status is : Comment Resolution, Not Started, Draft, NVX Review/ Comments Due Date is less than 10 days away I was playing around and got this far but its not working =IF(OR(Status@row <> "Not Started", Status@row <> "Draft", Status@row <> "NVX…
-
What formula(s) do I use to reference a Multi-select column in another sheet?
Normally I use Index(Match()) to pull in the value from one row into another sheet. That doesn't appear to work when the source is a multi-select column. I've tried Index(Collect()) but can't seem to get the syntax right. Any help would be greatly appreciated.
-
Formula to return 30,60, or 90 if Date is within 30,60,90 days
Hello, I need a formula to return a value of 30, 60, or 90 if the due date is within 30,60,90 days of a due date. I am going to use this column to group a report to show each bucket of items due in the time frame. I can get the formula to return the correct value if the date is within 30 days, but am not able to nest IF…
-
HAS Formula Returning Wrong Results
Hey Community, I've created a formula to count, collect, and return results based on some criteria. I have also created a report that gives me what I'm looking for. At the report level the results come back correctly, but in my formula to just get a count. It does not. =COUNT(COLLECT({Intensity}, {TargetDate1}, >-30,…