Mike Wilday’s Profile

Community member since February 2017

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


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


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


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.


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



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,