My colleagues from China cannot login to SmartSheet start from yesterday afternoon. Before it was OK.
He tried from different computers, also tried clear his borowser's history and cookies, but still failed. Then we asked friends from other cities in China tried to logon, they all have
Need some help. I'm sure this is a simple formula ... but I'm not Excel (or Smartsheets) savvy enough to figure it out.
I have a DATE column, and I have a FLAG column. If the date entered in the DATE column is more than 7 days in the past, I want the FLAG to appear in the flag
Now that i have a sheet that completes the sales process from contract through too invoiced/paid. The row needs to go to another sheet, I noticed it leaves the formulas behind and when i send it back to the original sheet I have to re-enter formula in cells
Can i duplicate a sheet so
I finally figured out how to create an IF formula to get an AVG of Children divide that by a specific number, and enter "N/A" if there was nothing in the children cells.
NOW my boss would like to Round the resulting number up to the next dollar value. Sometimes, I think she just likes to test me!
Set up a set of columns: lead, support and stage. I can get the COUNTIF formula to work for me to count the names of the people assigned in the lead and support columns, but I need help figuring out how to get it to also look at the stage column and NOT count that name if the cell in that column
1. I want to aggregate text information from child cells and use a line break as delimiter. How can I do this?
2. In Addition it would be nice to have "Primary Column" as prefix before the respective contents.
Values for Primary Columns for two rows: Child 1, Child2
Value for relevant