I'm working on transferring my excel system into smartsheet. I am creating a newsletter regarding events that happen during a certain period. In excel I can use a forumula based on a date. For example if the publish date is 23/5/2018, it will relate to events happening between 24/5/2018 and 3/6/2018. In excel , the event…
I am trying to auto populate a column based on a selection I make in another column.
I have a Sales leads sheet shared by 4 of us. Almost every time I move or amend a row and then SAVE, the rest of the leads jumble around and I have to move every thing back. Not sure what's the problem here! Can anyone help?
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…
Hi, does anyone have a contact number in the UK that works? my account & my whole company is locked out & asked to upgrade when we already have.... this is very urgent!!!
I have vendors fill out a form every time they have a shipment leaving their building. I want to create a widget on the dashboard for our leaders that show the total number of cartons leaving our vendors each day. (Bar Graph) But first, how do I create a report or formula to sum cartons by date, without me providing the…
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
I'm trying to convert an excel spreadsheet to a smartsheet. How would I convert this formula? =IF(SUM(AH6:AL6)=0,,AJ6+$AP6+$AS6+$AT6) Yeah, I am an extreme rookie when it comes to this stuff.
In the spirit of sharing, I thought I'd let you all in on the Arial Unicode Right-To-Left Mark character that can be used in forms to add blank row between Help Text and the form value. As per the image below: * begin by selecting and copying the U+200F character from the Arial set in the Windows Character Map application.…
Hi All I am really stuck with this as I need to amend my fomulas manually every time I have a new entry. Whenever there is a new entry ( via Web-form) I need to change the formula to include the new row instead of helping me with automation it has created extra work for me. Did any of you faced a similar problem? What…