-
hh:mm:ss format??
I am logging time spent per job using timesheet software, and the data it exports is in hh:mm:ss format. Is this date useable in Smartsheet? From this, I want to calculate a job cost. In Excel, I would do this by using the following formula: = hh:mm:ss x hourly rate x hours in a day (24) This would give me a £ value for…
-
SUM formula does not provide a total of IF statement outputs
Hi I have a timesheet tracker setup with a web form (mobile) to allow me to quickly keep track of my daily activities etc. There is a basic formula setup to auto populate my mileage based on a site code that I enter. =IF(LOC8 = "Home", "00", IF(LOC8 = "KH", "90", IF(LOC8 = "NP", "110", IF(LOC8 = "BP", "110", "xx")))) I'm…
-
How do I highlight columns on a gnatt chart
Hi Please could someone help me with highlighting columns on a resourcing sheet I have just created. I have the data on the rows and need to show when people are absent during the month by highlighting it. Many thanks Audrey
-
Is there a way to remove someone from Resource View without removing them from a project?
Unfortunately people come and go. They are assigned tasks, work on projects, etc and then if they leave, they need to be removed from the Resource View. Reassigning future tasks is acceptable, but we need the history and want to keep them listed on completed tasks. Is there a way to do this? I would rather not have to…
-
Row-level permissions?
I think I am asking the impossible here, but let's give it a go! I want to use Smartsheet for a career progression initiative, so the idea is to have a form where staff enter their details and ambitions. That's the easy bit, we can do that, The tricky bit is then allowing each member of the team to see and update their own…
-
Use of Form with Drop Down List
On a form is there a way to create a drop down list that allows the user to select more than on item on the list?
-
Conditional Formatting Based on Date / Number of Days
I have an sheet to track my employees. One of the columns is "Last Pay Raise Date". I would like to highlight a row when the number of days since last pay riase is greater then 180 days or something along those lines. Is that possible?
-
Sheet scalability
I have a sheet that I built for year-end performance reviews. The sheet is designed for one person. My company has 50+ employees and it would be great if I can run some sort of macro/app that would take the sheet and replicate it 50 times with each sheet adding a new name from a contact list. Any ideas? Thanks Ian
-
Web Form Layout
In webforms I have to make each item a column that I want info to flow into. Can I make those column print inot a row later? A long row info from columns is too much.
-
Hospitality Industry (Restaurants)
Is anyone using Smartsheet for their restaurant clients? My thought is to setup a wordspace run everything from new employee forms to inventory counts.
