-
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?
-
How can I subtract the hours worked from total allotted hours?
I am trying to track the total hours worked for an external vendor. We are paying for their service for a certain number of hours and each week I want to subtract the hours worked for that week from the allotted hours. I want a cell that gives me the total and subtracts out hours worked. I cannot, for the life of me,…
-
VLOOKUP Will NOT Work on my Date Columns
Hello Community, I am losing it on this simple VLOOKUP formula, for some reason I am not having a value returned on these 2 date columns. My current formula for one is the following: =VLOOKUP([Site ID]@row, {Cabling Date Range}, 15, 0) The column is the 15th column in the lookup range but it is saying invalid column value?…
