Himesh ✭

Overview

Overview

Roles	Member
Badges	2

About Me

About Me

Country	United Kingdom

Analytics

9

Posts

38

Visits

15

Points

Jun 3, 2024

Join Date

Aug 6, 2024

Last Active

Reactions

No reactions yet.

• Discussions2
• Comments7

Discussions

• Invalid formula error using IF AND

  Hello, I'm in the process of converting an excel spreadsheet into a smartsheet, but I've run into a problem. I'm trying to split 80% of a cost over a duration and then take a two month break before sh…

  

  Answered

  Formulas

  IF(AND

  Formulas and Functions

  145

  Jun 6, 2024

  10

• Two column types in one column work-around - #DATE EXPECTED error

  Hi, I'm in the process of transferring a spreadsheet into smartsheet that splits costs by months, and I've ran into a #DATE EXPECTED error for my formula. I can't change the column type as the formula…

  

  Answered

  Formulas

  columns

  Formulas and Functions

  81

  Jun 4, 2024

  3