abbie.smith90’s Profile

Community member since May 2019

points
52

5

Hi 

I am currently running reports which summarise an individual's outstanding actions across different smartsheets. The idea is that they can update the report rather than having to look at multiple reports however when trying to add in comments they cant - am I correct in thinking that they can

1

Hi 

 

Strange one but when inserting contacts the logos are appearing on different sheets differently. i.e. we have  David Thomas and David Ramage - on one sheet they appear as DT and DR however on the next they both appear with D logo - this could get confusing. Is there a reason why this happens?

1

Hi 

 

I am looking to do a nested if so if a value is x y is returned, see below details-;

 

  • IF COM = A
  • IF CR = B
  • IF HAR = C
  • IF ARF = D
  • IF AR = E
  • IF PSRF = F
  • IF PSR = G
  • IF 2020 PSR = L

I am having an issue with the below formula's (whichever way round I put it):

 

=IF(Type117 = "PSR", "G",