-
Forms or Formulas with appointment scheduling
Hello All! hope you can assist. Trying to have a form (external users fill out) to book a time slot - Once that time is gone - no longer available to anyone else and thus is removed from the options. Is there a solution, formula or best way to achieve this without using a third party booking tool? 🤔 Thanks Trish😀
-
Copy a date to a cell only if there is not already a date there
I'm trying to capture a date from a cell to another cell only if the current cell is blank Here is what I have so far: =IF(ISBLANK([Proposed PROD Release Date]@row), "", IF(ISDATE([Proposed PROD Release Date]@row), [Proposed PROD Release Date]@row)) This formula is in [New date] cell but I only want this to occur if new…
-
Smartsheets not staying saved.
Hi, I have a smartsheets that has a formula in that works out the number of days between a date and todays date. Therefore every day the No. days goes up and I have a dashboard off of this. The issue is that when the formula changes the No. days I have to manually go into the sheet and click save for it to get to the…
-
Index Collect Looking at Auto Number Column
I have an index collect statement in one sheet that uses a column with an auto number value in another table. I get an invalid value error with the formula. However, if I change the column type to text/number from auto number it works.
-
How to count cells with a value in a column
Hello, Trying to figure out how to count cells with values in one column. For example: I want to know how many cells contain a value on the following: Column 2 Josh Robert Alexandra Greg My ideal answer would be that there are 4 values in column 2. Any idea what the formula is for this? I have the formula for blank cells:…
-
Cross Sheet reference/"assigned to" allow multiple contacts per cell LIKE formula?
SS community - I need help. I have created a Sales Pipeline sheet for my sales team, sales stages etc which is basically it's own CRM. I am trying to gain metrics in order to keep the sales team members honest and report the truth to the leadership team. Challenge: Cross sheet formula (below) pulls correct data but when…
-
Calculate cumulative duration of time spent in each status where status changes are bidirectional
Hi, I have a problem I am trying to solve in a sheet that contains hundreds of individual requests. Each request starts with Status = 'New' and finishes at Status = "Complete" in between there are 3 review statuses, "Review Department A", "Review Department B", "Review Department C" depending on the department the review…
-
IF, Index, Match formula
Hi, I am trying to see if there is a formula that will look at the Cells in row 1, and if matched to the any of the weeks in column Week Of, will return the corresponding deliverable value in Column1. Attached is the clip of my smartsheet. Does anyone know if there is a formula that can do this? I have tried using IF,…
-
Valid sheet cell value becomes #INCORRECT ARGUMENT SET when aggregated into a report
Hi, I have a formula which displays the correct value at the sheet level =IF([Date Answered]@row = "", "", (YEAR([Date Answered]@row))) example output = 2021 or if there isn't a date present the cell would be blank. However, when I aggregate the sheet rows into a report the cell values show as #INCORRECT ARGUMENT SET Can…
-
Which formulae is it to compare 3 values and give me 1 of 3 different text options in a cell?
I have created a form that populates a sheet and the form asks multiple questions and then the sheet uses the answers to create 3 costs, so far very simple. However I want another cell to automatically display a result based on the 3 costs provided. I'm a contract manager and I will have 3 options I wish to display they…