-
if function for 3 criteria
Dear, I am planning to write an if function for 3 criteria. IF(AND([In Progress - Late]1 >= 1, [At Risk]1 >= 1),[In Progress - On Track]1>=1,) "Red","") I know I am writing it wrong. Can anyone help me structure the formula please? Cheers!
-
Project Resource View
I am trying to get the Project Resource View to work. However, I am having a few issues. 1. Only one name is showing up in the Project Resource View. How do I get other people who are assigned to tasks to show up? 2. The allocation shown for the one person who does appear in the Resource View is only showing up for one…
-
Time of Day
I have seen several forums related to Time of Day as a column option. This appears to be ongoing for nearly (4) years as a feature enhancement. Can someone provide an update and a simple workaround (not a long-winded formula option)?
-
Smartsheet - Dropbox - MS Word document editing on Ipad
Hi All, I have Word documents I am attaching to a smartsheet, that I would like a team member in the field who uses an Ipad, to be able to edit easily and save back to Smartsheet. Without too many steps involved. PDF is also an option. What are my options here? So far I can't get it to work with Smartsheet, attaching from…
-
Can I clean up my FORM email Text?
HELLO ALL, I am a newbie and this is my first submission, thanks for the comments. I created a form which watches the Audio Visual Rooms and reports to the Smartsheet when a problem occurs. It also sends an email to the helpdesk when a certain field (for emails) is checked. The email is generated from the AV SmartSheet and…
-
Translating Data from One Sheet to Another
I am looking for any method that could help me obtain the desired results. I have a tracking sheet titled “PM Sales Tracking” and within the tracking sheet there is a column that is called “Design Request” I have edited the column properties(design request) to a “dropdown list” with values of “yes and no” depending on the…
-
RYG Balls associated with Dates
I have search and tried multiple expressions and cant seem to get things to work correctly. I have columns: Estimated Start Date Actual Start Date Estimated Completion Current Finish Date Actual Completion Date What I would like is the RYG Ball to be blank for any row that does not contain an [actual start date]. Green if…
-
Formatting Options of Gantt
Is there any way to format the Gantt portion of my view/print? I need to adjust (narrow) the width of the Gantt columns so my chart fits on one page. Also, it would be great to be able to adjust the direction of the column titles (Jan, Feb, etc.) to display vertically, so I can narrow the columns quite a bit. I would also…
-
If/And, Date
Hello! Is there a way to checkbox a column if the following two conditions are met: IF the "Date Opened" date column is one day late AND IF "Date Closed" column is blank. One date late example - Opened 12/3 and not closed on 12/3, I want to checkbox.
-
Smartsheet Barcodes
Hello All, I have a sheet that has a specific barcode for each card. Ideally we would use the barcode functionality to scan an item, then select the option to bring you to the correct card. With it set up, when I go to test it, it only works occasionally. It will usually only bring me to the column that the card is in and…
