-
When saving as new, I want to break links including sumifs but I'm having an issue
I have a sheet that's linked into a pivot sheet via a series of sumif cross sheet formulae. This sheet is looking into the pivot sheet at a point in time e.g. month of April YTD information, and the Pivot will update monthly as new data is uploaded to the source report (I will also need the new data but the historical data…
-
Chart budget vs actual
Hello, I have a sheet where I can see budget, actual and variance for my project budget. So column 1 is january budget, column 2 january actual and column 3 january variance, and so on. All I want to is to create a line-type chart for my dashboard where I can see the comparison between the budget and actual numbers for…
-
Is There any option to make custom form using own html,or any functionality to achieve attached form
-
IF Function Condition - UNPARSEABLE
Hello, I have the following formula that does not seem to be working. =IF([Result]19<0,100%,IF((AND([Result]19>=100%,[Result]19<103%)),100%,IF((AND([Result]19>=103%,[Result]19<106%)),75%,IF((AND([Result]19>=106%,[Result]19<109%)),50%,IF((AND([Result]19>=109%,[Result]19<112%)),25%,IF([Result]19>=112%,0%,0)))))) For every 3%…
-
Formulas will be the death of me-
Firstly, formulas will be the death of me. My coworker wants to to do this- If the overall plan is 25% complete and 25% through the duration = green If the overall plan is 50% complete and 50% through the duration = green If the overall plan is 75% complete and 75% through the duration = green If the overall plan is 100%…
-
DataMesh - Updating ONLY new lines
Hi - we get two-halves of requests from separate parties, and I'm using DataMesh to link to things based on a Unique ID. Once the second half of the request is in the sheet, I don't need to update it again. Right now, my DataMesh setup is updating that row anyway - is there any way to ignore "old" or existing requests?
-
Automated Workflow Not Working
I set up a simple workflow. Once someone writes their initials in a column, it should move the row to another sheet. Except it is not moving the row to the other sheet. But when I look at the activity logs from both sheets, it says that a row has been moved from the source sheet and the destination sheet says a row has…
-
Helper Column Formula
Hi, I want to use a helper column to uncheck a Checkbox column if a certain condition is met. i.e. If [Order Date] contains a date then [Order Required] is unchecked. I can't put the formula into the [Order Required] column as it already has a =IF(OR(ISTEXT([Quantity Required]@row), ISTEXT(Unit@row)), 1, 0) formula in it.…
-
Has anyone found workaround today() doesn't involve zapier
We want functionality where "Milestones missed in Last 30 days" are highlighted. We can identify Milestones. What functionality do we use to count the rows that have missed the milestone? I've seen responses about Today() function having a daily-touch limitation. I'm looking for the exact Logic to get Milestones missed in…
-
Smartsheet re-opening automatically after hitting submit
Is there a feature that would allow a SmartSheet form to automatically re-open with a new form after hitting submit? we are using a form for each caller and it is cumbersome to hit submit and then find/click the link to open a new form.