Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for April 2017
Discussion List
Card Format - Report
I have built a report combining all my individual sheets to keep of ongoing tasks in one place. I want to be able to view this in Card View, but that doesn't appear as an option in the Toolbar. Is there something I can do?
Date problem
how can i change the date display in Chinese to US?
If then statement for Risk Management Matrix
Hi Folks - I'd like to feedback to write a formula that evaluates the following: =IF(Cell A1 "Acceptable" then??? Acceptable Tolerable Undesirable Intolerable "Then"... the statement should take the word "Acceptable" and give it a value of 1, repeating this same evaluation such that "Tolerable" receives a value of 2,…
IF(OR) Help needed
Hi All - I'd like to use a formula to evaluate status of red OR yellow then flag if red or yellow. I think I'm close but it's not working, please help. Here is what I have: =IF(OR([Status6] = "Red", [Status6] = "Yellow"), 1) (doesn't work) =IF((Status7 = "Red"), 1 (this works for red and sets the flag on for reporting…
Trouble importing from MS Project
I get a master schedule in a XML file and the basic info all imports fine. There is another data field which won't import for some reason. It is a text field with essentially "assigned to" info. Any suggestions? thanks Bill
Add Card appears in Row 1039 - each and every time - any idea how to fix the bug - thanks
Add card appears in Row 1039 in Grid View - I only have 55 Rows occupied with fields - i've deleted , refreshed, but makes no difference. Each time Add Card appears in Row 1039 - any idea how to fix the bug - many thanks
Outlook 365 Integration
I'm running Office 365 and within my desktop Outlook I have highlighted an email that I want to attach to a row in Smartsheets. I have the icon in Outlook "Add to Smartsheet". I open that icon within Outlook and I search for the Smartsheet. I navigate to the appropriate row and I can view all of the columns & data in that…
Gantt timeline doesn't match project start and end dates
Hello there I am a new user and am stuck! My Gantt chart doesn't seem to update project info from the start and end dates. Also the top bar of the Gantt Chart has irrelevant dates that I cant seem to be able to change. Not sure what I am doing wrong Attaching a screenshot . Many thanks in advance
IMAGE transfer to OTHER ROW/COLUMN using Formula?
Hello, Is there any way or formula I can use to transfer a Jpeg/Png file to other row without uploading it or using a formula? For example, I have Sample.jpg in my [1st Column / 1st Row] and I want it to transfer/copy that picture into my [2nd Column / 1st Row]. Thanks.
Statistical functions with if testing
it will be helpful to have statistical functions like Max, Min, Average etc combined with IF functionality like Sumif, Countif. Currently I have to create one column for first doing the if function in one column and then use statistical functions on the result column. When there are multiple fields it necessitates lot of…
