-
Creating a Form with Row information
I am looking to create a form that populates information into specific rows, not based on columns. I see a few discussions from several years ago, but nothing recently to see if this is doable. Anyone know if this can be done?
-
Copying cards and substasks
Is it possible to copy cards and subtasks in the card view and have the new lines generated in grid view? Make sense? Im trying to copy all subtasks for a new card but just have the user update the main task name. Thanks
-
Auto format drop down menu
Hello everyone, I am trying to set an auto format for drop down menu to give select options from another column's drop down menu. Does anyone know how I can accomplish this? Example: If Assignment is Compliance give me the 5 specific compliance options from a list of 20 on another column. Thanks in advance,
-
Sharing Question -
A workspace was shared with me, and I was made an editor who can share. For a specific SmartSheet in a subfolder underneath that workspace - how do I request to the owner that I want to be an admin of that SmartSheet in order to set up conditional formatting, send automatic alerts, etc.? I do not see any option of making a…
-
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…
-
Question about embedded webform and filtered sheet in confluence
Dear all, I did some research about the following topic but somehow got stucked and every helping hand is appreciated. What is the current status: Currently we are using smartsheet (lets call it "project_overview") to keep track on all our projects. After a few years this list is quite big (around 700 rows) so we are…
-
Help with nested If formulat
These formulas work independently. I am attempting to combine them into one nested if formula. 1) if the %complete is full, status is green: =IF([% Complete]10 = "Full", "Green" , "Red") 2) if the finish date is greater thant today, status is green: =IF(Finish10 > TODAY(), "Green") 3) if %complete is full and finish date…
-
VLOOKUP and Conditional Formatting
I updated our smartsheet team schedule to grab dates from my department's master schedule. However, the conditional formatting we set up that visually shows us when a project is nearing or past its due date no longer works on the VLOOKUP cells Is there something I'm doing wrong? Or is this a limitation of the software? Has…
-
Summary Row Card View
Hello, I cannot find any resources showing how to create a summary row card in card view. My lanes are based on stages of a project which is selected through a drop down on each row. I would like to total the NPV of each project that is in that stage (NPV is one of the columns in my sheet). How do I do this? Thanks!
-
Predecessor links disappearing when printing in PDF
Hello members, Need a quick help. I have a project and in the gnatt view the predecessor links are visible: See screen shot Gnatt mode. When I want to print this gnatt chart, the links disappear in the PDF mode. See screen shot PDF mode. Can someone tell me what am I doing wrong as I would like to see the predecessor links…