-
Hover over column to reveal full title
this would be helpful since I have some columns with long titles but the values are small numbers so the width of the column truncates the text... it'd be nice to be able to hover my cursor over the column header to see what it is.
-
Exclude values based on formatting
i.e. exclude red from a SUM function, so all the red values are not added up
-
Conditional Formating between 2 dates
I know how to achieve this in excel but can't figure it out here. We are looking to highlight a cell (or row) if the number of business days between two cells is less than 3 business days For example in a row we have: Date1 = 11/30/15 Date2 = 12/2/15 In this case above we would want to color Date2 red (or the whole row)…
-
Gantt dependency Start/End Dates not populating?
I have a Gantt Chart with dependencies enabled. When I shift the entire start date of the project all the dates shift appropriately so I believe it's working well. I've just inserted a new row and assigned a Predecessor Row and Duration. The bar appears to the right and dependency lines are drawn. However the Start and End…
-
cost and efficiency trend calculator
I just started using smartsheets for out development firm. we have hundreds of new consturction homes that we keep seperate data sheets on everything from bidding, to actual cost, to scheduling. I would like to be able to pull the data out of each sheet and generate a report that details how much I pay for each style of…
-
Still Looking for an IF function that does nothing to the cell if False
I asked about this back in April and got a few suggestions but nothing that really worked for me so I'll try again. I keep track of the hours charged to around 35 projects by people in a dozen functional areas on a weekly basis and send the monthly total into our finance team for their revenue recognition process. I use…
-
Smarsheet as a payslip app.
Is it possible? I need to automate my timesheet into a payslip afterwards. Tell me how can I do that? Thanks.
-
Users from another account
We have a vendor who is assisting us with a project and he already has smartsheet. Is there a way for him to have access to our sheets as well with his login or is that not allowed where we would have to setup another account with a new email for him? Did a search and couldnt find same question so bare with me if a…
-
Payroll
I am trying to set up a sheet that tracks employee hours for the week and any overtime or stop out allowance, has anyone found the best way to do this? Ideally I'd like to use a web form so each employee can pick up the web form, enter their information and it be transferred to a sheet for payroll. Many thanks
-
Two Separate Date Fields into one sum
I need to give per diem to employers for days worked for two events. Some will work one, some will work both. I have a formula that works great if they are working both events, but get the #MISSING OR INVALID PARAMETERS" message when only one event is worked. Does anyone know how I can get a column to return a "0" date?…
