-
When checkbox is checked harvey ball to show as full
I am trying to set up a formula using a checkbox and a harvey ball. Basically I would like the harvey ball to show as full when the checkbox is checked. The checkbox column is titled complete, once this is checked the harvey ball should be full. I have tried lots of different formulas and none of them are working the way I…
-
Is there a way to access the current time?
The function TODAY() returns the date but not the time component. I need more granularity, like a timestamp. The autonumber column types "Created" and "Modified" both provide such a timestamp.
-
Sum values from a column based on whether another column is empty or not
I'm trying to to sum values from the 'Value' column for a particular 'Reference number., but only if a third column ('Confirmation number') has a value. The actual value in the third column is not relevant, just whether it's been completed (confirmed) or not. I've got as far as this =SUMIFS(Value:Value, [Reference…
-
Sheet Summary Row, with CountIFS to determine % and Dynamic references
Hi all, Seeking Smartsheet Experts....! I have a Company Register with columns to identify documents and expiry dates. e.g. [A] Company Name, [B] License (Checkbox), [C] License Expiry (Date) 1) I want to calculate the summary of a count of All companies that do not have a license? 2) I want to calculate the summary of a…
-
Entire Row Reference in Formula
Is there a way to reference an entire row in a formula? I'm trying to count check boxes across an entire row, but don't want to re-write my formula if I add a column. Thank you!
-
Average % complete if task is assigned to "xxx"
What I am trying to do is figure out an assigned user's bandwidth. I am doing this by having them assign a % Complete to a task and then averaging the children =AVG(CHILDREN()). What I want to be able to do is average the children but only for specific assigned users. So average the children (% Complete) for tasks assigned…
-
Formula Column - Change Status based on %Complete
I have created a Column called Formula1 and I am wanting to use this column to create a formula that will look at the %Complete and If the %Complete = 100% (1) then change the status to Complete. Currently I have the following as the formula: =IF(%Complete1 = 1, Status1 = "Complete") Problem is I am getting "#NUMBER…
-
Getting the most recent item in a column
I am trying to create a project status entry form that keeps a running log of updates - and I want to take the most recent update and roll it up to a summary report. The data sheet looks like this: (attached) Line 1 is the summary line that will link to a master scorecard elsewhere. The value of [Report Month] on line 1 is…
-
function dates difference
Hello there! I am trying the function =TODAY() - [starting date]3 and I am receiving this number as result: 86.7854 how can I obtain jus a round number of days?
-
Connecting two formulas
I have 2 formulas that both work. I want to merge them into one formula but it is not working. =IF((COUNT(CHILDREN(Availability5)) = COUNTIF(CHILDREN(), "Red"), "Red", "Green" =IF((COUNT(CHILDREN(Availability5)) = COUNTIF(CHILDREN(), "Gray"), "Gray", "Green" It might just be time for lunch but what are the rules to putting…