-
Countif Formula based on Column
I am looking to find a formula that will count if it is a quarter column. My sheet has columns - Fiscal Year, Quarter 2/3 (etc.) and then Monthly breakdowns. FY1 Total | Q1 Total | Jan | Feb | Mar | Q2 Total | Apr | May ... And continues on for a couple of FY. I want to get a count of how many quarters have a value in it.…
-
Right and MID formula to pull from details sheet
I have imported my excel budget and details sheets into Smartsheet and unfortunately my formulas don't import correctly. I have struggled with rebuilding my formulas from excel to Smartsheet and that is the case with the below: =RIGHT(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255),5) How do I rewrite this in…
-
If checkbox is checked, add text to cell
Hello, I have a checkbox in a column named "Completed" I'd like to have a formula that adds the number "100" to a column named "% Complete" if the box is checked. I've read other posts and cannot get this to work. thanks!
-
Approval Workflow and SUMIF Formula
Hi, I have a form individuals submit when they request tickets for an event. Our sheet manager can either approve or decline the requests. If approved, I have a formula set up that removes the amount of requested tickets from the total. The request entry is copied to a separate sheet that has a calendar of each event along…
-
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…