-
Enhancement Request: Allow NO non-working days in WORKDAY function
I would like a small improvement to the WORKDAY function. For the third argument, we can pass in a range of dates. I want to pass in 0 or false or some other flag to IGNORE working days. =WORKDAY( {date cell} , 15 , 0 ) would return the date 15 days from now, regardless of project or global settings for non-working days. I…
-
Formula to display when a task is late based on start date and status/% complete
I'm looking to develop a formula that will visually (either text or symbol) show when a task is overdue based on a Start Date and the, either, status or % complete. I've tried to combine the RGY or the Harvey ball but that is using only one parameter and I need both columns. Thanks in advance community!
-
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!
