-
UK Contact - Issue with account
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!!!
-
Sum total number of cartons by date
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…
-
"Dashboards just got better"
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
-
Need Help with a formula
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.
-
Unicode character to allow blank rows in forms
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.…
-
How to make formulas work on top of a sheet if new entries are coming on the bottom of the sheet via
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…
-
Need help brainstorming solution for tracking forecasts
Hi Community! I've gotten pretty far with developing a new tracking process for our marketing teams by scouring the questions and answers already posted here. However, I'm stuck on something that I haven't been able to figure out and am hoping you guys can help me brainstorm a way to solve it. I'm using smartsheet to track…
-
If and Formula tracking date, progress with ryg status dashboard
To share back with the community here, I'd like to share some key formulas that I've been helped with by the community and extensive testing/fixing. I have a sheet that tracks: * progress for items based on user inputs of %age complete * compared to the progress they should have completed so far (%age expected as of the…
-
Magazine Project Sheet?
My department manages the production of a quarterly magazine and uses SS for the editorial/content management process. Here is the sheet we currently use: https://publish.smartsheet.com/c95e42926fad4be7ae3463eaf2b228da I'm wondering if this seems like the best process, or if there's a simpler solution to a project that…
-
Conditional formatting for parent/child Kanban cards
I have three parent sections and each has a few children. I'd like to have the conditional formatting of the task bar be different so if something is under Parent 1, it's got an orange card etc. I can't find a way to do that so it's automatic for all new rows added under a parent and would hate to add a repetitive column.…
