-
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…
-
Virtual Time Cards - Contractors Working Remotely - Timecards
We manage a group of independent contractors that work off site. We are looking for a design of a web form so they can record the hours worked daily. This would have to allow for start time, lunch time (punch out), lunch time (punch in), and end time. Looking for a formula to calculate the hours worked daily, weekly, and…
-
Multiple Sheets - SUM Dollar Totals in Report
I did a quick search in the community and didn't see this answered exactly, but i think either an Excel export or a future release of Dashboards may provide a quicker/better solution. So here's what I'm trying to solve. I've got 10 sheets that track Paid Claims. When the Claim is paid, a field titled "Date Payment Received…
