# Dan Seidler’s Profile

points
183

When an employee leaves the company, we want to deactivate a User, but retain their data on our sheets (for history reference).  If we choose "Remove User Sharing Access", will this simply remove their ability to log into our Smartsheet account?

The Status remains "Active" for this employee.  Is

As the Smartsheet Admin, I create most of the Sheets, Reports, and Dashboards for the Executive team.  When we transfer ownership of all Sheets, Reports, and Dashboards to the Executives, their Dashboard Chart Widgets all state "Source Missing".

Smartsheet's Help Desk provided this response:  "...

Wondering if this is possible: I am trying to create an IF formula in a checkbox column where, based on the Start Date of one of the rows, if the date is in the future, it will not be checked, but if the date is today or in the past, it will be checked.  I was playing around with the below formula

The goal is to count the number of days that an Employee is not assigned work within a given month (MONTH A, MONTH B, etc).

For example, a given month has 23 working days; I could use NETWORKDAYS of the duration to count the assigned days of that Task; say 19.  To reach my goal, I would simply

Hi,

I'm not able to get the sum children to calculate on the parent column and still showing a zero amount.  Any suggestions?

The formula I've created isn't working correctly and I can't figure out what I'm doing wrong.

=IF([New NCN Score Total]120 = 15, IF([New NCN Score Total]120 <= 14, IF([New NCN Score Total]120 <= 9, IF([New NCN Score Total]120 <= 6, "Very Good"), "Good"), "Poor"), "Very Poor")

Scores

15 = Very Good

Here's the working statement:

=IF(AND([Account Owner]191 = "JK", [SALES REP]191 = "JK", OR([BILLED BY]191 = "Merit Medical", [BILLED BY]191 = "Don Joy"), STATUS191 = "Paid"), CHARGES191 * 0.14, IF(AND([Account Owner]191 = "JK", [SALES REP]191 = "JK", OR([BILLED BY]191 = "Cerapedics", [BILLED BY]191

I'm trying to create an If/Then/Else statement to determine if an employee is eligible for a pay increase.  Essentially, the formula needs to say

IF Mandatory Training Requirements Met = YES

AND Corrective Action = NO

THEN Eligible for Increase = YES

ELSE Eligible for Increase = No

Any thoughts on

I can't figured out why #INVALID DATA TYPE auto fill when I haven't pick a date for the start and finish date. If I do have those fill out then the formula works fine but otherwise it just fill the duration cell with that error. I do have the duration column under Text/Number. The only thing that I

I need to first find the column number where the number 1 resides on the "Lookup Value -->" row.

Next, I need to shift two columns to the right, which would be "4/2019 C" and sum the values for Client B,

I have tried various combinations of SUMIFS, INDEX(MATCH()), etc.,but with my last attempt, I