-
Back Tracking Dates
I am trying to create a formula that can generate a date 2 weeks prior to a set date. For example: 9/1/17 - 14 days = 8/18/17 I assumed the formula would be as simple as "=[cell w/ given date] - 14" but it will not work and the column is a Date Type. Any suggestions?
-
using dates in countif formula
Hi all, I have an issue, I need to use a collumn with autonumber system format, in this case i have used date. the problem ocurres when i need to count all rows created in a specific date, it seems that the systems does not count the dates with hours after 5:00 pm or assignes the next day date if the hours surpases 5:00 pm…
-
Predecessors and Formula's Error when I delete rows
I have a master sheet that has tasks for all types of projects and depending on the customer we sign, I will go through and delete the rows I no longer need. The issue is that my RYG (error: #BLOCKED) and Predecessors (error: #REF) error when I do this which means I then need to go back and correct them manually Is there…
-
Using pointers for relative addressing
Greetings: Is this possible in smartsheet? (I have searched through the list of functions, a video on the use of cells, and the community but have not located any info on this.) Would like a formula to look at the current row's dependency and treat that value as a pointer to reference the value on another column in the row…
-
Automate RYG balls
Hi, I am just getting started with formulas. I'd like to automate the colors of my RYG symbols based on the dropdown options in another column (see screenshot). If Status column is Event Scheduled - Green If Status column is Event Declined - Red If Status column is anything else - Yellow. Can you tell me how I would write…
-
Auto row numbering not functioning problem
I created a new task list and set the auto row numbering in my first column, and set to document my tasks. Saved the sheet and then moved on to other things. The row numbering at this time is set correctly to 1 - 10 type of thing. I then went and added additional rows at the bottom and the dates and then wanted to sort the…
-
sumif date is today to end of month
Trying to write a formula that doesn't need manual updating that basically sums a total amount for file that have a closing date from today to the end of the month. Seems like it should be fairly straight forward but I cant get it to work. The sheet has parent rows but i want to include all rows in all parent rows in the…
-
Auto Indent When Using a WebForm
I have some formulas on the 1st row and everything underneath are indented in order for the formulas to work. However, when a new entry comes in via the webform. The new row does not indent automatically. Does anyone have any suggestions? Thank you!
-
Nested IF AND & OR
Hello, I'm looking for a good formula to collect the number of remaining days to work. This works fine: =IF(OR([Assigned to]110 = "User1", [Assigned to]110 = "User2"), [Closing date]110 - TODAY(), "0") but If I want to add one more condition like at row status it doesn't works: =IF(AND((OR([Assigned to]110 = "User1",…
-
Date Formula based on Last Modified is off
I made a column i called Status Date. I used the Formula: =[Last Modified]1 so that it would just display the last modified, but also have the option to be over ridden manually if need be. My problem is that the Last Modified is showing Today (7/20/2017) but my Status Date field, which should show the same date, is showing…
