-
Write Function that has 2 check boxes in it?
Hi everyone, I have had smartsheet for awhile and finally taking the time to learn/use it and am stuck. I have a custom apparel business and have made a sheet to keep track of all my orders and what the cost will be. I have columns for Quantity, Balance, No Fulfillment (check box), and Paid (check box). I have a working…
-
Linking the text in a cell to a document
If I have a PO # that occurs in multiple cells. Is there a way to link the PO# text to the actual document? I don't want to link the cell to another sheet. I want to link the PO# text to the actual PO document. So a team member can simply click on the link to view the PO.
-
Mobile app doesn't show dashboard graphs
I can't view any of the graph widgets on the mobile app. Is this a known issue or are my settings wrong?
-
Formula Assistance
I am attempting to automate my project list by scoring each project based on calculations in another sheet. I would like to create a "Project Score" based on drop-downs in my project sheet. Sum=Complexity*weight + cost*weight + impact*weight +resources*weight + value*weight. The values of each category and weight are in…
-
count values where two columns match
i am trying to count the number of matching pairs of values in two columns. eg: Column A Column B 1910 760 1910 810 1910 810 1990 760 1990 760 the outcome of the above that i am looking for is as follows 1910 x 760 = 1 1910 x 810 = 2 1990 x 760 = 2 can someone please help me with a formula that will give me these count…
-
Where do you record action items in the meeting template set?
We have been using another procedure in the past for our meetings whereby the agenda is at the top and as each topic is discussed, action items and the person assigned to them is on a separate section below. I seem to missing a similar provision with this template set or am I missing something?
-
Template document control
If you create a template in Smartsheet, does that template have any type of document control, history, or revision numbering assigned to it? We need to keep control of revisions to the templates and would like to know the best practice for this in Smartsheet. Thanks
-
Forumla HELP! Check boxes then counting £ values in columns
Hello community This is my first post, struggling to achieve a formula command. can you help? I have several columns, one being a check box column named "Payment" When one or more of the rows is checked within this "Payment" column, I then need the system to calculate the £value across three other columns, names "30 days"…
-
Scrambles Subtasks
Is there a reason why my subtasks keep getting mixed up in different entries? For Example, Job "A" has 10 subtasks, Job "B" has 5 subtasks. Once saved, Job "A" showing all 15 subtasks???
-
Turning Off Card View
Is there a way to disable Card View permanently or "shut it off"? Our company uses things in Grid view and we would like to disable the function to avoid confusion.