-
Best method for saving updates across 2 sheets
Hi, I hope all reading are well! I have a question relating to the best way of obtaining updates across 2 smarsheets. Sheet 1 contains multiple columns of data, which are imported on a weekly basis from a 3rd party app. Each week the data from the previous data is overwritten with the new data. In Sheet 2 I would like to…
-
Update a cell on a master list from individual identical laid out sheets
I have a template that I use to create data sheets for unique projects. All rows and columns are the same for each project. I also have a master sheet that lists all the projects which are populated with information from the same cell location from each project sheet. I have been able to go from the master sheet to the…
-
Automate symbols
This should be easy but I am stuck trying to figure out how to get the symbols to work in a formula to reflect health of budget percentages. All the single lines work except the green one - it just shows up blank, with no error (the highlighted drop-down has the green formula only like below) I have tried the combo forumla…
-
COUNTIF CHECKBOXES FROM MULTIPLE SHEETS
I NEED A COUNTIF FORMULA FOR CHECK BOXES IN MULTIPLE SHEETS =COUNTIF([Priority Vendor]:[Priority Vendor], 1) +COUNTIF([Priority Vendor]:[Priority Vendor], 1) SHEET A SHEET B
-
Formula to List all Sub-Task Owners in One Cell
I am hoping to have a column/cell that indicates all team members that contribute to a given project (ideally in a contact list column type). Is there a formula that could reference only the child rows and compile certain child row cell values into a comprehensive list? For example: For Project A (shown below), Bob is the…
-
COUNTIFS to pull data from multiple columns
Hi everyone, I'm running into an issue trying to count the number of times a word appears in a 10 column range (SCPD Log Range 9) in a one month period. I have a column that assigns the month its respective numerical value and the same for the year. I'd expect this formula to look across all 10 columns and count how many…
-
SUMIFS returns no total with one line of data
We are using this SUMIFS and COUNTIFS as part of our caluclations for critical path. They have been working fine for the entire team, except one member who only had 1 project meeting the criteria. Is that why all the forumulas are returning a zero for her? Is there a way to tweak this so any number listed is returned? The…
-
EDATE Function like Excel
Hi! Date math in Smartsheet requires fairly complex formulas for anything besides adding days. Can we add something like EDATE from Excel? This allows you to add a start date and a number of months to generate a new date.
-
Count cells containing text only, excluding text with digits
Hi, I need help with a function/formula: I am looking at counting the number of crew (they are listed by first name) and at the same time exclude any cells with text & digits (names with quantity). I hope this makes sense - I did some search and cannot find any formula that does the job. Many thanks, Thanks, Salèha
-
Move row workflow not running
hello i have run into a problem where i have a workflow setup that automatically moves a row to another "Active" sheet when the decision column is set to active, and it works fine when i do it manually but i tried to add a vlookup formula to pull from another sheet that is filled from a form since you cant use forms to…
