-
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…
-
Conditional formatting with heirarchy and card view
Hey All, I'm having difficulty getting my card view tabs to show a certain color based on percentage complete for the subtask. When I create the rule it either highlights all the subtasks based on the parent percentage complete, or does nothing at all. I am trying to have individual subtasks change color base on…
-
Conditional formatting and uniquely identifying cells
Hi, I would like to only apply conditional formatting to cells that are percentages. My rules currently set any cells that are over 100% as red, and 100% or less as green. Due to the red rule formatting any cell over 1.01 a lot of my data is showing as red, wheras this really needs to be white, there is no cause to flag…
-
SumIfs Formula is not working out.. Trade1:Trade5, "Demo", Cost1:Cost5
I am really struggling with the following formula.. Below is the list of my columns of data that comes in automated into a sheet, by way of a webform I have about 50 trades, like (demo, framing, electrical, plumbing etc).....I want my formula to reference the trade column, and pick up only the entries for "framing" to date…
-
Cashflow formula - IF formula issue under date formatted column
Hi, I'm trying to create a project cash flow projection sheet and I'm stuck with the (see attached photo) IF formula. I need the column to be formatted as date to find the IF formula but I cant format the cells below as number/text and I believe this is the reason that the IF formula isn't working. Any help to get this…
-
Use Today's Date by Default in Web Form
I've created a task list which I enter tasks via a web form. I have a Date Entered field in the web form. I would like to make this a hidden field in the web form and by default enter today's date into my task list when I submit the form.
-
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"…
-
Update Requests, reminders, notifications
I'm wondering if there is a way to set up automatic update requests, reminders, and notifications to be sent on a reoccurring basis until a task has been marked as complete? I see where I can choose to have these emails sent daily, weekly, and so forth. But I don't see where I can tell Smartsheet to stop sending these if…
-
Export Web Form
Hello. I am trying to use SmartSheet as a relacement for an audit form. There about 90 questions on the audit that would be answered with a selection of A, B, or C. Ideally, those would be checkboxes, but the sheet does not allow duplicate names in the columns. I would like to be able to pull a clear report from the data…
-
Sights needs some improvements
Sights has been out for about six months now, but there are still no graphing widgets. When is SmartSheet planning on coming out with this functionality? Graphs are some of the main things people will look at when viewing a dashboard. Currently all we can do is list a whole bunch of raw numbers with little to no visuals. I…
