Mike Wilday’s Profile

Community member since February 2017

points
1416
Company
University College at Azusa Pacific University
Department
IT & Operations
About Me
Skilled with SmartSheets reporting, formulas, cell-linking, sheet setup, etc.

4

I have a formula that  says it is an incorrect argument. When I break up the two arguments they each work, but they are not working together. The error message is incorrect argument.

I don't know why they work alone, but will not work together.

 

Here is what it looks like when I added them

2

I'd like to try and figure out how to most effectively and efficiently connect 2 separate smartsheets together, preferably through some sort of smart formula/code. I don't think doing a manual "cell linking" from a cell in one sheet to the next would be very smart or efficient for what I'm trying to

2

How can I convert the 1-5 Stars Symbol into a number using one formula. I have one column Stars and the one with number should be Rating.

I also don't know why they chose to have it convert in Excel to Empty, One, Two, Three, Four, Five. Why not numbers?

Thanks for any help.

4

Hi, I am still in the beginning stages.

In calendar view, I seem to be missing some data from my sheets.

One of my sheets has all data showing on calendar view, another has half and yet another has none.

I assume it's something I'm doing wrong---but what exactly

thanks

2

I am modifying the "Help Desk Ticket Tracker & Form" template.  I don't want to double-enter the date, so I deleted the 'date' column and am using the 'Created (date)' system-generated column.

When I use the webform, it will fill in the date created.  But if I add a line directly in the smartsheet,