-
Top up a column with another column value
I have two columns in my sheet, one that is ACTUAL HOURS, and one that is WORKED HOURS. Every time users enter worked hours, the workflow automation takes those hours into that user timesheet, and then clear the WORKED HOURS column so that user can re-enter other hours at any later point of time… at the end of the task…
-
Adding One More Criteria to Working COLLECT Formula
I have a working formula where I need to add one more criteria to a COLLECT function but can't seem to get it working. Here is the current working formula: =MEDIAN(COLLECT({Platform Test - Submit Status to Intake Date}, {Platform Test - Quote Testing Completed Date}, AND(@cell >= $[Start Date]$1, @cell <= $[End Date]$1),…
-
Sum if week is the same - or blank if none
Good afternoon, I'm sorry for a somewhat redundant question but I've not been able to get this to work. I need to sum up the hours if the days are in the same week. But, if no date, leave it blank. I have a date column that could be used and a week of the month column. This is one of many formulas I've tried.…
-
Report showing activity per month grouped by resource
Hello, I have a report gathering from 6 different sheets all with the same formats. I am grouping the report by resources so I can see each resources activity and how they overlap. I would like to take this report and only show a single months activity (and not necessarily the current month). I want to pull up each month…
-
Date Range in Date Column + Automation
Hello! I have an automation that currently sends users alerts based on the date in a column called "End Date". A majority of the time, the end date is a single date. However, sometimes the end date can be two or more days (ie- May 7th-8th). While I can write into the date column ="May 7th-8th", that will prevent my…
-
How can I
I'm trying to find a way of updating the column Term Expiration Date with the New Term Date column. I currently have a workflow that once a date is entered into the New Term Date it copies that row to a new sheet. The problem that I am running into is if I use the Data Mesh, or Data Shuffle it tends to update…
-
I need help making an at risk formula for the 2 percentage columns.
Hello, I am very new to smart sheets and am currently creating my first. Can someone please help me use the above screen shots of the chosen symbols in a formula green being percentage complete is >or= to the percentage that should be complete, yellow being percentage complete is 1-25% < Percentage that should be…
-
Keyboard shortcut to delete a row
Hi Everyone, I am used to working in excel and using keyboard shortcuts to navigate my sheets without having to use a mouse. Is there a keyboard shortcut to delete a row? if not can how do I let the product team know to add this to the development queue? thanks!
-
#BooleanExpected in Report only - formula works fine on sheet.
Hi, I have an "if" formula in my sheet that checks a box and has been working fine for months. Today, out of nowhere, I'm getting a "BooleanExpected" error on the report that relies on this sheet - although the checkbox is still operating correctly on the sheet. Formula: =IF(AND(NOT(ISBLANK([Date Inspected]@row)),…
-
Return a date or month
Hello! Is it possible to write a formula to get the following result - Start Date Column: if it's a confirmed date, a date two weeks earlier in a photography due date column is calculated (this works by using this formula: (=[START DATE]@row - 14)) HOWEVER, if a start date is TBD and I put in the Start Date Column "March…
