-
Round Robin/Cue Function?
Hello, I'm looking to incorporate a simple round robin feature, i.e.: Column Header Titles: C1) Unique ID C2)A C3)B C4)C Step 1) Person S uses simple form that only requires Person S to enter a unique ID - the person enters that and saves it Step 2)That information entered would be saved to column C1. Step 3) That…
-
Auto fill information in sheet when a check box is checked in a different sheet?
Hi! I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. Essentially, all I want to do is autofill the check box on sheet 2 once it is checked on sheet 1. Is this possible?
-
How to calculate the number of days past due
Hi, I'm new to smartsheets! I'm trying to determine the formula for the following: The project plan has a due date and and actual date completed, if the due date has past I need to determine the number of days late based on today's date or if the actual date completed is past the due date.
-
COUNTIF to determine the occurrence of "specific text" from another sheet.
I've been able to find close approximations to what I'm looking for, but have one missing piece. I have a summary sheet ("summary") that pulls data from another source form evaluation sheet ("source"). Essentially, I have a workflow in place on the summary that when stakeholders are identified for a specific client an…
-
Populate a text value based on a date range
Hi All, I'm fairly new to Smartsheet and I'm trying to set a text value based on a date range. Reading through all the responses it seems possible but a little messy. All I'm trying to do is automatically populate a Quarter value based on custom ranges. No cross sheet references, all in the same sheet. When I only use two…
-
Add a specific condition to an existing formula
Hi, I am trying to ad a specific condition IF(TD<[@[DUE DATE]]+7,"PIPELINE" to an existing formula. However, the existing condition IF(TD<[@[DUE DATE]],"CURRENT" is interfering with the addition, and I cannot figure out where I am going wrong. I tried all sort of combinations. The complete formula is:…
-
CountIfs Dates with ISBLANK Continuation
I am having trouble with my formula. I'm a newbie and my logic be flawed and terrible. Learning in progress. I thought I had received the answer but as it turns out I was still trying to acquire more information. Essentially what I want to do is run the calculation below: =COUNTIFS({Action Plan Week Requested Date},…
-
Countif coming over as percentage
Hello, for some reason I have one formula using a cross sheet reference that comes over as a percentage when the rest come over as values which is what I want. I really don't understand why the "complete" formula is coming over as a percentage and not an exact value. Thank you in advance for the help
-
Formula to check the cell for 4-5 text strings
I have a condition where in the formula should check the text in CELL A and return value based on the assigned values and should leave the formula cell BLANK if none of the condition is satisfied. I tried it through spreadsheet and the formula is: IF(OR(A1= "Name A", A1="Name B",A1="Name C",A1="Name D",A1="Name E",A1="Name…
-
Ref SUMIF example in Help
Hi, Referring the SUMIF example in the Help article https://help.smartsheet.com/function/sumif, it is not clear to me why =SUMIF([Price Per Unit]1:[Price Per Unit]3, >20, [Transaction Total]1:[Transaction Total]3) has the result 3,115.00, and not 2,303.00, that is 1,491.00 + 812.00 Thank you, Elena