-
Card view - spanning lanes
Hi Is it possible to have some fields in the card view span several lanes? Thanks, Galit
-
Simple email capability?
is there any way to load an email address into a smartsheet cell and then send an email to that address simply by clicking on it?
-
Conditional Formatting on Parent Line
I created conditional formatting that allows me to color code based on % complete of child tasks, however this does not carry into the parent line as I have dependencies enabled. I would like to be able to visually show the progress of a project based on the average of the children status on the parent line.
-
Excel spreadsheet with calendar and schedule
Good afternoon, I hope someone could please give me some ideas if it's at all possible to do with smartsheet or in excel??? I have an excel spreadsheet that was created by a professional. I'll try to explain the information it has on it and what I'd like to do with it. It has the date, Hebrew date, and then in in many…
-
Conditional Symbols $ to $$$$$
Hi All, I went looking for the below but did not find it, so i built it. Use the below for a 1-5 symbol column like ($-$$$$$) to conditionally set the value based on a column in your list. =IF(Saving1 = MIN(Saving:Saving), "One", IF(Saving1 = MAX(Saving:Saving), "Five", IF(Saving1 = AVG(Saving:Saving), "Three", IF(Saving1…
-
Managing Resources by duration and not % allocation
Is there a way to manage resources by time rather than having to use % allocation please? Any way aound this? Its actually not that easy to manage using a %. Sad that smartsheet didn't think it would be an important feature. I'm no software expert, but seems like not too difficult a fix if they already implemented it for…
-
Hiding Rows, Columns from Client or User Access
Hello. I've searched and thought but I want to ask the question anyway: Is there some way I haven't found, to hide a row or group of rows (or only show the ones you want) from a user or published view and keep those sent rows in an interactive environment? Heres the situation: Out of my 200 row sheet, I only want to show…
-
Alerts to non-shared resources
We are trying to implement an editorial calendar. Smartsheet works great for this in theory.. ie: we have the primary row as an calculation that shows us: "Client (Content Type) Title (Creator name)" - perfect. this is awesome. We have the due date as the calendar date. - Again.. perfect. HERE IS THE CHALLENGE We have…
-
Smartsheet integration with Eloqua
I see there is an integration with SmartSheet and Marketo, does anyone knows how it works and if there is something that can be done to integrate with other marketing automation tools like Eloqua.
-
Add requirement to formula is a cell is blank versus not blank
Here is what I am trying to do for our contracts: Cells I'm working with (for the formula) • Contract Start {Date} • Contract End {Date} • Remaining Days {Number} // formula =[Contract End]1 - TODAY() • Contract Status {Dropdown - see below} // formula =IF([Remaining Days]1 < 0, "Expired Contract", IF([Remaining Days]1 >…
