-
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",…
-
Calendar view of all Projects, the resources assigned to the projects, and their associated allocati
We are looking for a way in SmartSheet to present all projects (ideally, can be sorted/filtered by workspace) and the resources assigned to each project, and the associated allocation in a calendar view. I have created a quick mock up of the presentation attached. No capability to do Reports in the required Calendar view.
-
App notifications
Maybe I'm missing it, but is there a notification that can be sent through the app when web form is submitted?
-
Highlight Row if column is "true" and date is 7 days greater than....
Access 2007... I am creating a report tracking spreadsheet. Basically consists of a column of report numbers (column A) and then different locations that report may be sent to with a checkbox column... if checked, the column next to it displays date it was checked. I would like to highlight a row if the report has not been…
-
auto refresh
Is there a setting for auto refresh. What I have been running into is when I go to use the next available row....for instance row 5, a coworker can be entering at the same time in that row without my knowledge. I then fo to refresh and everythng he put in is mixed int o what I put in. It may have the adress or lacation of…
-
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…
-
Ability to see Smartsheets side by side
One of the things that I am wishing that I can do is to be able to display two smartsheets side by side with each other, right now I'm only able to present the smartsheet that I am in unless I login to smart in a second instance of explorer and then put the two IE windows side by side. Has anyone discovered an easy way to…
-
Transfer/Move/Copy Rows from one sheet to another, and keep formulas..?
I need to transfer rows from one sheet to another that contain formulas. I know that the simple copy and move options just transfer over the values of the cells, but I'm really hoping that someone has found a clever way around this. We've totally overhauled our use of SS and this little deficiency could be a show-stopper.…
-
Auto-Copy Formulas
I was having some problems with standard =this+that*something formula not copying down when I add a row. When I add an IF() statement to the formula, it seems to work. I noticed this, because all of the IF statements in other columns were working, so I thought I'd test the theory (add the IF()), and it worked. Anyone else…
-
How to automate putting rows (based on conditions) of one sheet to a second sheet?
Hi, My sheet 1 has a structure with column 1, 2, and 3. My sheet 2 has a structure with the same columns as sheet 1 - column 1, 2, and 3 - plus new columns column 4 and 5. Based on values in column 2 in sheet 1, I would like to export the row in sheet 1 that satisfies a condition, to sheet 2. Once sheet 2 is updated, I…