-
Check button on form to check calculations prior to submitting the form
I am creating a end of day banking form to include all cash and eftpos transactions recorded currently in Excel. It would be great to have a Check button that checks all the calculations against a formula column to ensure it balances prior to submitting the form. If it is incorrect then it would produce an error and not…
-
Need Help with Collect or Index or Lookup. Help please!
I have a grid that is pulling YTD actual expense from another source. I have added a helper column to the right of YTD budget. I have a sheet with the exact same layout that includes year-to-date budget expense. I am trying to select the correct month from the helper cell (ie - "Apr-26") and have the YTD budget pulled from…
-
Connecting Automation to conditional formatting
I am trying to figure out a way to attach automation to conditional formatting. For example, I have 4 columns, with the last one being a checkbox or another standardized trigger. I want to send out a notification that a row has been added, only when the checkbox in the last column is clicked. I set that up already because…
-
AI is #NO MATCH for the Smartsheet Community
I've tried the AI feature and other third party AI sites but cannot get this right. I know somebody here can help. What I am looking for: On the parent row of a date column called [2B End Date], I want to evaluate the children rows of the hierarchy group, and if the column [Modification Type] (which is a multi-select…
-
NETWORKDAYS formula returns unparseable
Hello smarties… I have used the formula for newworkdays to give me a duration between two dates, but the return is unparseable. Any help. Here is what I have done: the columns being referenced are date fields there is no spacing commas used instead of semicolon to sep arguments brackets are used column headers have spaces.…
-
Reports - How do I add a specific cell from every sheet
I have a workspace that has several sheets and I want to create a Report that shows me the cell Column5 row 6 from each of those sheet, and if the content of that cell is equal to a specific content, then i want that sheet to be on the report. After that I want to add Column6 row 3 to the report from every sheet that met…
-
Does SmartSheet have an equivalent to Excel's "Name Manager" and "LAMBDA"?
I need a way to label a specific set of data or create a custom function that can be used in cross-worksheet formulas. Related to another query of mine, I need to take a list, give it a specific name, and reference it without having to navigate to the source sheet every time it's needed. For example, let's say I have a…
-
Cross-sheet references maxed out
I'm building a large master reporting sheet that cross references multiple other form response sheets based on a shared "incident number". I have six more columns of data to pull over from another sheet but have maxed out the cross sheet references (100 per sheet!) This master sheet then uses that data to create pdf's. I…
-
Issue with COUNTIFS Formula Referencing Auto Number Column in Smartsheet
I am currently working on implementing duplicate detection logic in our Baseline sheets within Smartsheet. The requirement is to identify duplicate Project Codes and assign a sequential baseline order (1st, 2nd, 3rd, etc.) based on the order in which rows are added. While attempting to implement the logic using a COUNTIFS…
-
Networkdays bring back #INVALID DATA TYPE error
Hi, I am trying to get the networkdays from 2 diffrent dates. Here is my source data. I have the same formule for diffrent type of packet movement. Here is the formule I am using to retrieve the dates to a diffrent sheet. Here is the formule I am using to get days between the 2 dates If I take the formuls out and just type…