-
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…
-
Hello Everyone,
I would appreciate some assistance in finding the most appropriate excel spreed sheet template to track all my purchases throughout the day. Thank you!
-
% of children
Hi, I want to calculate % of checked children in the sheet below, can anyone help me? https://app.smartsheet.com/b/publish?EQBCT=41482d287b58426b801642f8c4cd31f0 Niclas
-
Enhancement Request - Color Coded Tabs
It would be nice to be able to color code the tabs with an indicator on the left or right "ear" of the tab. I use letter prefixes to code for Report (R), Template (T) etc, colors would be a lot slicker.
-
Smartsheet Labs - Map
Love the map feature as a quick and easy way to view all of my companies locations and break them down by state or any way we need. I wonder if there would be any way to get county lines include on the maps though.
