-
Returning a cell value if false
Hello all. Pretty new to Smartsheet here. I am trying to create a call that checks if one column, Trip, contains a value 1st, if it does NOT contain the value 1st, I want it to populate the contents of the corresponding cell in column Job Description. I keep running into errors attempting to nest the cell call =[Job…
-
Am I the only one who does not like the new December 2018 look?
I'm struggling with the new layout and welcome any suggestions. I do not have the dashboard level subscription - just below that, I think. I HATE that I have lost my tabs, and I hate that the menu button ALWAYS takes me back to the RECENTLY VIEWED as opposed to the Home. This new layout just seems like more work to manage…
-
Identifying and returning phrases within a single cell
Hi all, I have been trying to figure it out alone but I thought I'd engage the community to see if anyone can help! I have a column in my spreadsheet that contains phrases separated by commas - for example (though with different words), in one cell it says "Phone, computer, mouse, cell phone, water bottle, earphones, bag."…
-
Data Validation
How can we validate data at cell level? I want different cell ranges (in the same column) give me different drop-down options. Right now I see that we can validate data at column level and not at cell level while Google Sheets and Excel allow validating data at the cell level. Please suggest should I do? Thanks!
-
Row indenting is not working
I am having problems indenting rows on my sheets. I have parent rows that I would like to have child rows beneath. However, when I click the indent on the child rows, the cursor on the parent row is missing. My cells have data, and there are now hidden blank rows. Also, when I go to delete a child row, it gives me a…
-
Link comment
Bonjour à vous I would like to know if it is possible, to have a quick access of the good line in smarsheet when you link a colleague and you leave a comment with the @ and they open it in a email ? All the time when they open it, they are redirect in the master sheet... Merci
-
Nested IF(ISBLANK & Date Columns w/Progress Bar
Hi Everyone! I would like to know if you are able to use date columns when automating a progress bar. Basically dates are entered as product moves to a new stage in the process. As the dates fill in, the progress bar fills as well. I've used nested IF formulas for automating a progress bar but, for whatever reason... Im…
-
Tabs No Longer Showing
Sometime last week I noticed my view in Smartsheet (using Chrome) no longer has the tabs at the top of all of the current open sheets. How can I get this view back? It was much more efficient than the pinning option we have now. Also, the recently reviewed Smartsheets would be great if it actually filled up that column but…
-
How do i add more than one duration to a gantt chart?
I have a project that has hundreds of tasks. Each task has a fabrication duration and a delivery/logistics duration. How can i add an extra column and add the extra duration per task to show in the gantt chart in maybe a different shade or different color? The other solution, would be to add a line below each task just for…