-
Autofill based on the new entry in another sheet
I run constantly to the same problem and decided to shout out for help. Basically my problem can be defined as cross sheets conditional autofill. My case: Sheet 1 (offers) - sales people add data about new offers with the web form (that's OK) Sheet 2 (orders) - I need to bring data from the sheet 1, if offer's status is…
-
Allowed Values depending on Value in another column
Dear Smart Sheet Users, as a newbie, I'm not familiar handling depending possible values in Smartsheet. We want to approve a deployment process. If a user chooses value 1 in column A during data entry then there should only be a sublist of possible users to send the approval request in column B - if a user chooses value 2…
-
Nested CountIf statement help needed
Hi, I need to create a formula where if a box is checked in one column, a figure in another column gets included in a sum in another cell at the bottom of the column with the numeric value. This is what I've got, but I'm getting error messages: =COUNTIF(QTR:QTR, "True", SUM(Blackline:Blackline)) I'm not sure exactly what…
-
Formula help
I have a date column for bid due dates. I'm trying to create a formula that gives me a count of how many rows have a due date coming up in the next 30 days. So far nothing we've tried has worked, not sure why. Does anyone here have a suggestion?
-
Automate Formula Criterion
I'm sorry if the answer to my question is available. I could not find information about automating a scheduled update criterion included in a formula. For a monthly dashboard, I created a series of formulas to count the number of topics at various development stages, total days in each stage, and the cycle time between…
-
Parent-Child Formula for Percent Comnplete
Good Day All: How can I change the following formula below into a parent child relationship so if I add additional rows, the parent will automatically include the child in the calculations for overall percent complete. Does anyone have the Smartsheet % Complete Formula that is hard coded within the Project Settings? Thanks…
-
Automatic Target %Completion by Date
Hello, I'm trying to configure a column to reflect the Target % Completion based on days from Finish date but am hitting a snag for Finish Dates that have passed (resulting in a percentage higher than 100) or Start Dates that haven't arrived yet (resulting in a negative percentage). (I do understand that you can't add a…
-
Nesting IF Formula
I have been reading though the discussions and have attempted to nest the IF functions but I am having difficulties with it maybe someone will be able to help me. We are using check boxes to track numbers when checked. I created the function and got it to work. =IF([PRHT Wrap Claimed]10, 10, 0) The issue I am having is, we…
-
Help on formula: Return value
Hi all, I am building a project tracker however I am new to creating formulas so please need your help again. Based on the image below, I wanted to get the Stage and the Progress of the project that will later complete my summary report by just displaying the main headers in yellow. On row 1, Stage column, I want to get…
-
SumIfs Current Month
Hello, I am trying to sum hours noted in the children of a row (Total Hours per Project) if the current month is noted in another cell (Week Ending With). Here is what I have: =SUMIFS(CHILDREN([Total Hours per Project]1, [Week Ending With]:[Week Ending With], MONTH(@cell) = MONTH(TODAY())) and I continue to receive a…
