-
Pop up form requiring description
Hi Everyone, I am trying to create a checklist for my organization and have everyone check off on their task by inputting a "yes" or "no" using a drop down list indicating weather the task is completed or not respectively. What I want to happen is, if they answer "no" on the Smartsheet, that there will be a pop up of a…
-
Data Uploader - Expressions & Repeated Updates
Hello, I have three questions regarding Data Uploader. 1) In my source excel file I have First Name and Last name. I tried to build an expression to concatenate the fields (used =[First Name]+" "+[Last Name] but returned UNPARSEABLE which I would assume is because I am not referencing the line number. Is there a way to put…
-
Return "Late" if date is passed and box is unchecked
I have 3 columns: Planned Date, Completed Checkbox, Late I want a formula to put "Late" in the (Late Column) IF the (Planned Date) is passed and (Completed) is unchecked. If it is not late, I want to leave the Late cell blank. I want this to show on every row. Here is my formula for row 2. I'm getting #INCORRECT ARGUMENT…
-
Automate a rent increase on certain date
I am trying to automate a rent increase on a certain date. I have a table with Tenant ID, Rent Increase Date, New Rent amount. I would like to reference this in another sheet, so that when the rent increase date arrives, it will return the new rent amount. I can use the Index and Match to pull in the amount, just needing…
-
=Today()
Im putting this formula into a cell in a date/time property column and it returns the text "=Today()" ie with no functionality.
-
IF FORMULA HELP
Here is my IF formula: =IF([% Complete]3 = 0, "Red", IF([% Complete]3 = 1, "Green", "Yellow")) It works great for green and everything else not so much. What I want it to do is calculate based off of percent complete. so if less than 50% complete it should be red, if less than 75% yellow everything else is green. What have…
-
How can I take a concatenated string and feed it into a form as an option?
Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form. In the sheet, I have a 5th column that concatenates all of the 4 fields. (It basically builds a unique name for each of our customer audits) and looks like this.. 2019_Jun_Fab5_Skyworks…
-
Unparseable error being returned
I am not finding the error in my formula, Client is a text field and Start and end dates are Date fields. Any help would be greatly appreciated Regards Michelle =IF(AND([Client]1= "In Progress", [End Date]1 < TODAY()), "Moderate", IF(And([Client]1 = "In Progress",[End Date]1 = > TODAY()), "Mild",IF(And([Client]1= "Not…
-
Sumif or ifs...
Hi, I want to sum a column based on multiple criteria from one column. I have accomplished this in the following way: =SUMIF({Stage}, "Proposed", {Volume}) + SUMIF({Stage}, "Sold", {Volume}) Is this the best way to do this or is there a cleaner way to accomplish the same thing. Thanks!
-
Dynamic drop down list
Is it possible to link a drop down list to a query from another sheet column. For example It would be great to be able to have users select items from a list of the top ten sold items. This list would update as sale demand changes. or being able to only select items of a certain type based off another column.