-
Add or Remove Text from Cell
I have an import from a system that looks like the below. I need to standardize the data in another row with either all prefix 'Nav-xxx' or all excluding 'Nav-'. Any idea how to do that??? Thanks in advance
-
Is there a formula that will work for this?
I'm trying to pull a start date from a sheet into the sheet summary if the bucket is a certain bucket: I've tried the below formulas but keep getting #UNPARSABLE: =IF(CONTAINS("1.2 WON", Bucket:Bucket), COLLECT(Start:Start, @row)) =IF(bucket;"8.1 CURRENT DUE DATE",(VLOOKUP(xx/yy/zzzz,start:start, 8)) The bucket doesn't…
-
successions to control yes/no for multiple Rows
The formula I have came from Smartsheet support, and it got me close but not there yet. =IFERROR(IF(AND(CONTAINS(row@row, Successors:Successors), HAS([Overall Status]:[Overall Status], "COMPLETE")), 1, OR(=IF(AND(HAS(Successors:Successors, row@row), HAS([Overall Status]:[Overall Status], "COMPLETE")), 1))), "") I am trying…
-
Help in setting customer importance based on their average sales price
Can anyone help me develop a formula please? I would like to set a level of importance for customers. I would like to see if their sales price is more than the total average or less. If its more, I would like to set an importance text field to "RED". Is it something like : =IF(AVG([Sales Price]:[Sales Price]),>[Sales…
-
How do I capture a location ?
hi I know that from form u can choose location , but user can choose any location by him self . is there any way to collect the location where the user are ? for ex : user choose location x , but he is in location y , i need to record current location .
-
Cross-sheet formulas - affecting two cells when only one selected
Hey, I am cross-referencing "total paid" from a budget sheet into an over all activity sheet; however, I have two cells (in the activity sheet) that though I am selecting different sets of figures (from the budget sheet) in the formulas they keep reflecting the other. when i change one, it changes the other. and visa…
-
VLookup, Index, and multiple criteria
Hello all- I am trying to return a value from one sheet on a summary sheet based on two different criteria. I have attached a couple of screen shots. If the YMCA Name on the "Summary - Association Attendance by Committee" sheet equals the YMCA Name in the row of the "Summary - Association Grid" sheet, return the %…
-
Max(Collect formula
I'm trying to pull in the most recent date of a file, and it looks like =Max(Collect is the way to do it, but I'm having trouble with getting the formula to work. Currently, I have =MAX(COLLECT({Date of Recent Update}, {Parent Folder}, [Delivery Path]@row)) where Parent Folder and Delivery Path would be the reference to…
-
How to Count Requests Submitted within a Certain Time Period
Hi! I am using a Smartsheet Form for users to submit requests to my team. I have a column that automatically generates when the request was submitted (month/day/year time of day). I need to be able to count how many requests we are getting for each hour of the day to justify shift hours for my team. Is there a way to…
-
Create Percentage Based off # of Checkboxes Checked
1) Creating a percentage to tally how much out of each section is checked completed. 2) Then also need to setup a formula to do the same for the overall sheet including all subheaders. This is the formula I have so far for the individual subheader sections. But I keep getting Invalid Operation errors. Not sure what I'm…