-
IF(AND(DATE(YEAR
Hi Team, If(and( this MONTH/YEAR date matches the [Comms Due Date]2 MONTH/YEAR date then return 2% of [Current Month Sales]2 dollar value or nothing. (Text number cell) =IF(AND(DATE(YEAR([Comms Due Date]2), MONTH([Comms Due Date]2), ([Current Month Sales]2,*2,''-"))))
-
Search content within an attached document and metadata
Saw a bunch of post about search and it not searching what everyone needs it to. My suggestion, the two biggest features of SharePoint are SEARCH and RESTORING deleted rows (items). SS - C'mon man. You gotsta prioritize this. Admins have to sleep at night.
-
An Admin deleted bucket
Saw a few threads regarding years of no action by SS to give the Admin the ability to restore deleted rows. My suggestion, why not allow users with edit rights to delete rows, but not allow them to see the deleted items. This is where the admin will go when the team screams that someone deleted a row or rows. SharePoint…
-
Invoicing formula, am I on the right track ?
When a job is invoiced say on and between Jan 1st till Jan 31st (Invoice Date]:2 then the commissions will be paid the 20th of the following month Feb 20th[Paid Date]:2 Im assuming a nested If statement would be needed for each month? assuming of course. If someone can help get me stated, that would be very helpful. Thank…
-
column colors change from two different column status
I have a colored ball column that states if something is overdue from the due date to make the ball red. What I want is the ball to turn back green if the status changes to Completed. I tried this =IF(ISBLANK(Due3), "Gray", Status3 = "Complete", "Green", (IF(Due3 < TODAY(), "Red", IF(Due3 = TODAY(), "Yellow", IF(Due3 >…
-
Conditional format using two columns
Hi, I have two columns Planned start and Actual start. I can't seem to set a conditional formatting rule when Planned start is not equal to Actual start. Please assist. Y
-
Setting a conditional format when a date is e.g more than a week ago??
Hello all I am fairly new to Smartsheet and am trying to create an 'orders overview & management spreadsheet' for our family business. I want apply a conditional format to a particular date column so that if the date entered is more than 7 days ago, it will highlight the cell in red & bold. I can't seem to do this with the…
-
Preserving Task Rollup in a report?
I would like to create a report to be sent out on a recurring basis that is essentially a filtered version of a report, (i.e. only showing tasks that have not been completed and filtered for tasks for a two week period in the future. I've been able to set the selection logic up in the report, but it does not bring the…
-
Check if cell is empty then join.....
Hello, Friends. New user who like Smartsheet very much. Situation: A general user provides input via the smartsheet form. Once the form is submitted, column B is populated by a Smartsheet number generator (next sequence number). Works great. I have built a JOIN which runs great manually. I would like to run the JOIN only…
-
inadvertent formatting
Hi, I seem to have pressed a key or series of keys that has pushed the contents of some number cells over to the right a little thus shaving off a little of the number and i can't work out how I did it. Please see screenshot. Anybody got any ideas please? Thank you. Si.
