-
formulas in a form
Hello, I've created a form with an email and a user name field. I would like the user name to default to the value entered in the email address field. Is there a way to use logic or formulas in the construction of the form to accomplish this? I realize I could use a formula in the sheet itself but wondered if it could be…
-
Help with a Formula for Status Change
I want to create a formula that changes the status colors to red, yellow or green. Below are the criteria: IF Due Date is < Today and progress bar is not "Full", then "Red". IF Due Date is > Today - 3days, and progress bar is not "Three Quarters", then "Yellow" All other scenarios = "Green" Any help or suggestions would be…
-
How to edit this formula to start my day at 6:30am.
Hello, I am using this formula to count my fiscal week and it works just fine, but every Monday at midnight, it switches to a new week. I need it to delay the change until 6:30am. How can I edit this formula? =ROUND(((Modified@row - DATE(2020, 10, 25)) / 7) + 0.49, 0)
-
Why does the SUM function always deliver the value "0"?
Hello everyone, I have integrated my smartsheet account with a formbuilder service (123 formbuilder). Smartsheet perfectly shows and updates all data which I gather through my various forms. Integrating all data into one giant mastersheet works fine as well. But I am experiencing a small problem with the SUM function.…
-
Row-Average of Percentages in cells
Hi, I am trying to do the average of % (data in percentage) in a row. Few of my cells are blank too. Rest all data is in % format. Formula i am using is avg(selecting the rows) Error getting is #Divide By Zero Please help
-
Calculating SUM pending on dropdown selection
Hey all, I'm trying to calculate a sum pending two different drop down selections but having challenges with making it work. Any help would be greatly appreciated! =IF(OR(Coverage@row = "Travel", Coverage@row = "Local", Coverage@row = "2 Locations"), (SUM([# of Shifts]@row * 12))), (OR(Coverage@row = "Planning Only"),…
-
SumIF from another sheet
Hi, I have a formula that sums up the expenses for a particular billing code, like this: =SUMIF([Account Code]:[Account Code], "539023", [Expenses Submitted]:[Expenses Submitted]) This works well, however, I want to use this code on a different sheet, without having to link to a bunch of cells on the first sheet. I can't…
-
Setting up a Workflow
I have a column in my Smartsheet for responsible person. I would like to set up a workflow that will send out an email to the person that is placed into the responsible person column, but would like to set it up where only one email is sent out for all items shown for that specific person. Is this possible? Do I need to…
-
Formula/Summary Function
I want to be able to summarize how much our locations are requesting in funds, can someone help me with a formula? Column A - Month Column B - Date of Request Column C - Amount Column D - Agency (single select dropdown) Column E - Use of funds (multi select dropdown) Ideally I'd like to summarize column C, by column D -…
-
Formula Help Countifs and Match
I'm trying to develop a cross sheet formula that will give me an error message if I've over-allocated equipment. This is What I've come up with so far but I get Incorrect argument. =IF(COUNTIFS(MATCH([Equipment Required]@row, {Equipment Total}, 1), >[Equipment Max#]@row, {EDBDate}, >=Start@row, {EDBDate}, <=[Last…