-
Cell linking - From column to a row
How do I get around where cell linking puts my data? I’ve created these columns in my roll up sheet.(first capture) Now I want to link and have all the data display in a row. (just like you see in the second row, (I had to cell linked each one individually, not good) My source data/intake sheet, data is listed vertically…
-
Can't access any sheets when they're shared with me
Hi, whenever my boss tries to add me as a viewer to sheets we use to keep track of clients I never receive an email telling me the sheet was shared to me, and the sheet never shows up in my "shared to me" tab. I can't figure out why this is happening. On her end, it says that she shared it with me and i'm listed as a…
-
Printing View/Dashboard Title in Color
Hello, Is there a way to print a view/dashboard (to pdf) that retains the color background of the title shapes? The text in the widgets do print in color - it's just the background of titles that reverts to white. thanks, -Peggy
-
Dropdown to determine value on another column
A little help... I want to use a dropdwon column value to populate another cell with a predetermined value from a lookup column. The attached screenshot - Unit Type is the drop down and I want it to correlate to a value from pricing columns and populate the unit rate column.
-
Groups dropping from Alerts
Hi everyone, Has anyone had issues with Smartsheet groups dropping off alerts that have been setup? I've had this happen 3 times now and I have to keep adding them back. Thanks for any advice.
-
Forms- Multiple guests contact informatio
Hello, We are using a form to RSVP to company events, for these events we have our team members inviting guests. The form is sent out by email to our team members and asks to provide their guest count, then we ask them to add their guest's contact info (name, company, email and phone number). The problem we have ran into,…
-
Notifications when a date is now in the past
If a date in a cell under a date column is now in the past (i.e. the date hasn't been changed, its just now in the past) if it possible to automate a notification reminder to someone to do something? All I can see in the notifications capability is the ability to send a notification if a row is actually changed or added.
-
Help Desk Dashboard
Has anyone created a Dashboard that links to a Help Desk SmartSheet? I'd like to be able to have a Dashboard that shows users the status of all tickets submitted, so that multiple tickets aren't submitted for the same issue.
-
Formula involving multiple IF/AND statements
I need to modify the following formula to include additional AND conditions. =IF(Finished12 = 1, "Blue", IF(Target12 >= TODAY(+14), "Green", IF(AND(Target12 >= TODAY(+7), Target12 < TODAY(+14, "Yellow", IF(AND(Target12 < TODAY(+7),%COMPLETE>70, "Red")))) The additional condition would be in the third if and would be…
-
System Generated Time Stamp Issue
I have a project that needs to count how many lines are added on a particular day. I found that dates convert to the next day after 7:00 pm. I've tried (=dateonly) and the date still advances after 7:00 pm. I need to be able to capture based on the true date. Does anyone have an insight into a solution? Thank you