-
Summarty roll-up sheet - Date error
Hello, New issue here. I am trying to do a summary roll-up of some sheet metrics. my goal is to publish this to the dashboard for ease of use. All of the metrics are based on the top cell (in green) called "Mother ID". When this number changes, so too does the associated info. One of the metrics I am trying to pull is a…
-
How to create a Sheet Summary for the last 7 days ?
I am trying to find out how to summarize (count) the number of items that have been completed in the last 7 day? but my formula is reading 0? i think there might be a syntax error =COUNTIFS(Complete:Complete, "0", Created:Created, TODAY(-7))
-
Forms that need to incorporate multiple line entries
We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is filled in and the 'save' button pressed Are we able to set up a Smartsheet form to…
-
Specific cell reference in update request text
Hello! My examples are in French, but as SS is the same, you should understand with the visuals. I used a template as a base for my project management office. In this example, we create a folder with the project name, but all the subfolders remain “generic” in order for the links between them to continue working if we make…
-
Uncheck box when another cell is not empty
Hi everyone, hoping for some help with a particular workflow I have been struggling with. The short story is I'm hoping for a formula that unchecks a field when another cell is not empty. The longer story is: We use a checkbox that triggers a request for clarification from our customer. It sends them a form, with a cell…
-
tryin to if function with OR and AND
Hi All, If there is a date in 'date found' column and date in 'Date collected' column, Column7=Collected if there is a date in 'date found' column but no date 'Date collected' column, column 7=Uncollected if the 'Date found' column is blank, column7=blank Can anyone please try help @Genevieve P. @Paul Newcome can you…
-
How to enter a formula referencing other cells within Duration?
Hello, I have a column where I indicate the budgeted hours available for a task. Within the Duration cells, I would like to enter a formula that takes the budgeted hours, divides them by an efficiency factor and yields the resulting duration available for the task, however, I'm unable to enter any formulas into the…
-
How to reverse the order in which a range is counted?
Hello, I have the following Smartsheet: In this Smartsheet, I'm building an asset booking system and, for the 'Asset Available During Your Booking Date Range?' column, it displays whether the particular asset is available for the date range inputted by the user. My formula is as follows: =IF(IF([Asset Booking Start…
-
Is it possible to suspend all automations for a row based on status?
I have a SmartSheet with numerous automations based on the Status of the line item. One of the Status options is to put the project on hold. Is there any way to halt/suspend notifications and other automations if the status is on hold?
-
I need to add the number of days in one cell to start date and it needs to be in workdays
I have one column with my start dates and a second column with a varying number of days that need to be added to the start date, and I want the resultant date to be in workdays. I have tried various formulas and have not been able to find one that pulls the value in the second column to add to the start date. Suggestions?