Hello! I'm trying to create a formula that will generate a weighted sum total across a couple of criteria columns after each column has been assigned a score. Each of the columns will have a drop down where we can select a score (from 1 - 10). Each column will have a different weight: Enterprise Priority: 35%; HR Priority…
Hi, My company is currently using Smartsheet for Onboarding tracking and workload. There are 10+ people working on the sheet and I wanted to know if there is a more immediate process to have the sheet auto save instead of saving after 1min of inactivity, that way everyone can see what is being worked on in real time?
Where the first instance of 'Days Not Worked' for a member of staff occurs (the first date of that person's annual leave), I want to input a distinct value (only once) in the column 'Deduct N/A Annual Leave'. This is the sum of, where manager type is Company annual leave, the number of days in a date ranges between…
Hi, I am trying to incorporate 0.5 days of annual leave into my vacation tracker. I have the forumla =NETWORKDAYS([Start Date]@row, [End Date]@row, {Bank Holiday Lookp}) to calculate overall number of days out (minus public holidays). From this total I then want to include any 0.5 days from this when 'half day requested'…
Hello, I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and two of the columns have a rather complicated formula, which has a function I don't believe is available in Smartsheet (COUNTA). When I've tried to replicate it I get an error message (UNPARSEABLE) The formulas are:…
Hello, I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and I've been able to recreate a good portion of the columns that have complex formulas, but there seems to be a number of discrepencies with some of the data where it is out by a few thousand pounds or a couple of percentage…
Hi there, I am creating a new employee onboarding spreadsheet to assist our new hires in getting familiar with the company and have come across a roadblock. I want this spreadsheet to be reusable for different employees as they start in a department. I want it to function similar to this link at the bottom where it creates…
This discussion has been merged.
Has anyone made an org chart in Smartsheets?
The formula works, but it is not solving the equation and is giving me the words of the equation instead =IF([Per Diem Eligible (Yes/No)]@row = "Yes", "25*[# Nights]3", "")