-
COUNTA alternative in Smartsheet
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:…
-
Data doesn't match the data from Excel when replicating formulas
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…
-
Certified Smartsheet user on the look out
Hey friends, Anyone hiring experienced Smartsheet user, if so let me know! 😁 I've been using Smartsheet for 6 years, it's so much a part of my daily work productivity and I'd like to seek out another opportunity where I could transition my skills and background in program management into. I've gain so much knowledge and…
-
Onboarding Spreadsheet Help
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…
-
Merged: A cohesive/real-time ability to work with multiple people within a sheet at the same time.
This discussion has been merged.
-
I am trying to create a formula - If I Select "Yes" then multiply 25 by a specific cell.
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", "")
-
How to add "Reasons Why" to the Decline action of a Approval Workflow
I am working on a an extensive approval workflow with numerous steps and approvers. I am running into a challenge with getting the reasons why someone is declining a request to be part of the automation. Is there a way to allow for the user to input comments to support their reasoning for hitting "Decline"?
-
One Data Set, Multiple Calendars
I have a sheet set up for publishing to Outlook calendar. "PTO Detail" is the primary column and displays on the calendar. I need to create a second calendar with all of the same dates with the second column "PTO Detail Team". What's the best way to go about this? All of the data is input via a form, and both calendars…
-
Best Practices for Employee HR Dashboards
Hi - I am trying to create a dashboard for each employee in our company that contains their personal HR data (such as time off balances). I've created several reports that I would like to share with each user on a dashboard. Normally, I would utilize the "current user" feature and create one report for each element, one…
-
Sum, Count and maybe IF statement.
Hello All, I’m needing help with creating a formula that seems a bit complex to me. I think it’s really a two-part formula or more. My data will span across two different sheets. My first sheet (Accepted Job) will have data where team members have accepted a Job on a new shift. The important data from this sheet is area,…