-
Formula for Status
I would like to auto create a status based on an end date, completed date, cancelled checkbox or on hold checkbox. If end date is in the future an neither checkbox is selected then "Open". If the end date is in the past then "Overdue". If complete date has been entered then "Complete". If cancelled checked then…
-
Unparseable Error
Dear Smartsheet Community, Very new to Smartsheet and having trouble with 2 formulas that work in Excel. =IF([Date Approved] = 0, [Date Calculation],"Completed") =NOW() - [Date of Submission] Could you kindly let me know if the formula structure is incorrectly done? Would appreciate your input. Thank you. Best, ~ Rowenna
-
Automate Risk Flag
Hi All, I am struggling with trying to find and create a formula to automate the Risk Flag. I'd like to use simple logic to provide a flag if any of the ancestor rows have one of the following values The two columns are Status, with dropdowns, and Risk Level with High, Medium, Low Symbols, and I would like to return a red…
-
Hi, can anyone help me to get my Green/Yellow/Red/Blue Status to work correctly?
I have to write a green/yellow/red/blue status indicator with a risk override field as well. The concept is that if the Risk Override field is populated then that should be the status. The risk override field will be a drop down between Red and Yellow. If that is not populated, then it should be Blue if % complete is 1…
-
How to use cell input as column name in formula?
Hello, Is it possible to use a cell value to fill in the column name within a formula? We add a new column each week. I would like to do a simple COUNT function, for example. Instead of updating the formula each week, I'd like to update the value in a cell that the formula will reference. So instead of…
-
Using SUMIF to have a blank cell if data comes back zero
I am pulling data from another sheet. I am using a SUMIF to sum things off a certain date and if it meets a certain name. When it has no data to bring back, it shows a zero and I would like for the cell to be blank so that my charts do not show a lot of zeros. How can I do this? Thanks =SUMIFS({AIC-Diverts 2020 Range 1},…
-
Formula Help
Hello- I am trying to subtract the most recent # of vaccines on hand from the sum of the total vaccines delivered- any suggestions? Tried this but it did not work: =(SUM([If you got a shipment, how many doses were in it?]2:[If you got a shipment, how many doses were in it?]61)) - (INDEX([# of vaccine doses on hand today…
-
Help counting duplicaes in a column but not blanks
Hello, I want to count duplicates in a column but not count blanks. Any assistance appreciated. Az This formula works but it counts the blank cells =COUNTIF([Name (Last, First)]:[Name (Last, First)], [Name (Last, First)]@row) This formula results in all '1's but doesn't count blanks. =IF(COUNTIFS([Name (Last, First)]:[Name…
-
Formula to show text next to sum amount
Good day, Our Currency ( BHD for Bahrain Kingdom ) is not one of listed currencies and I wish to show it to amount numbers , how to have Currency BHD seen next tp total sum in below formula ? =SUM([Service Charge]4:[Service Charge]13) Also , is there a way or formula to show text ( BHD ) or any other text next to number…
-
Help! Not sure what formula to use???
I have one column labeled, "Earn "C" or Better?" which is a checkbox column. If the student earns a C or better, our financial aid department awards them the money in the column labeled, "How much is the student receiving?" I need to summarize my sheet to show the total amount of dollars dispersed to students receiving a C…
