-
Not new, but I wonder if there is an smart advance tutorial for Smartsheet for not so smart people
I love using Smartsheet, but I am almost positive I am using just 0.00001% of its capabilities. I appreciate your input.
-
IF(AND(DATE(YEAR
Hi Team, If(and( this MONTH/YEAR date matches the [Comms Due Date]2 MONTH/YEAR date then return 2% of [Current Month Sales]2 dollar value or nothing. (Text number cell) =IF(AND(DATE(YEAR([Comms Due Date]2), MONTH([Comms Due Date]2), ([Current Month Sales]2,*2,''-"))))
-
Hyperlinking Images?
Hello- I am working on converting an inventory spreadsheet that is currently in excel and moving it over to Smartsheet for additional functionality. I would like to include images - is it possible to actually hyperlink an image once it is attached? Thank you!
-
Monday of date
I have an installation date column and a "week of" column. In our "week of" column, we keep the date of the Monday before. As an example, if the installation date is 1/19/17, the "Week of" column should be 1/16/17. Or, if the date is on a Monday, (Installation 1/23/17), the "Week of" column should be the same as the…
-
Conversion Formulas / Cell Linking
I am cell-linking 2 sheets but 1 sheet records time in days and allocation: Example: 2 days and 50% Allocation = total of 8 hours spent on the project over the course of 2 days. (The duration can not be changed from days because this is our project management sheet and we use in the gantt chart to share with customers.)…
-
IF/AND Statement to yield check box answer
Hi Smartsheet wizards. I am trying to create a formula for the following logic to track my teams contact with clients. Essentially if a team member hasnt contacted a client within 30 days, to produce a check mark. We have a small team so I planning on copying this formula to a seperate column per team member and then…
-
Including only the most recent comment.
Hi there, Within the "Print Setup" for .pdf reports, under "Options", "Include comments" checkbox....when selecting this checkbox it prints out the full set of comments which is fantastic but can make the report quite lengthy, especially over time. However is there a way, or is it possible in future upgrades to select an…
-
Gantt Chart - Show Repeat activity every fortnight / month etc
Hi All I am wanting to show an activity that needs to happen every week or month on a Gantt chart in one row. Any suggestions please?
-
Conditional formatting based on Cell History
Hi Is there a way to format a row - based on when a partcular Cell was modified rather then when anything in the row was modified? In this example I would like to format the row based on how may days the Client has been at a particular status Thanks Lee
-
Work around to formulas across sheets
I am working with 2x sheets - one a CRM, the other a job list. I would like to be able to flag on the Job list when a customer name is entered which is not already in the CRM. In Excel I could use a combination of ISERROR & MATCH to achieve this, however from what I can work out formulas across sheets is not possible on…