-
Collect Hours Spent or Planned Hours for Projects using the "Business" plan only
Is it possible in the Smartsheet Business plan to utilize a form to input daily hours by a team member that would add up all hours spent against a project? I was thinking of creating a "Time Tracking Sheet" to be populated with new projects using the "copy project" automation workflow from a Master Tracking Sheet. Have the…
-
Using COUNTIF to return fields that contain certain test data
Hi Smartsheet Community, I am trying to create a Sheet Summary field. I want to count how many times my primary column has "D:" in the task name. When I use COUNTIF it returns fields that only contains D: in the field. (See my attached pic). Is there something that I am missing or should I use another formula?
-
COUNTIFS and SUMIFS functions?
I created a sheet that is a roll up of various information derived from a master sheet. I am using this to create a dashboard. However, I am stuck on a few formulas. I tried SUMIFS and COUNTIFS, but I cant get it right and either get invalid ref or unparseable. I would like to be able to count the number of stars appear…
-
Help with formula for "If column matches another sheet, check the box"?
Hello there, I am trying to get this result: If Branch # on this sheet matches {Branch Number} on reference sheet AND the {Month Name} on the reference sheet is "January", check the box. Thank you!
-
Subtracting Days from a Date
Hello, I am trying to subtract 30 days from a column pulling in dates from another sheet using formulas and it keeps yielding an #INVALID OPERATION error. I have already checked and do not have dependencies enabled. Both columns are formatted as date columns. While playing around I noticed when I add the days it instead…
-
Blank do not Concatenate
Hello, I have a cell i use to concatenate a varying cells into one line and divides each text by dashes. Currently i'm using =column1@row + "-" column2@ow + "-" +column2@row Is there a way to spin the isblank( or if(blank formula so that if all columns 1 2 or 3 cells are blank it would not use the formula so that the…
-
Help with text formula based on date range
I'm trying to create a formula that essentially does this: If [Due Date]@row occurs next week then "Next Week" ELSEIF [Due Date]@row occurs last week then "Last Week" I was initially doing this with WEEKNUMBER, but that doesn't work when today and due date are in different years. I then tried doing date math by comparing…
-
Multiple Forms to One Sheet
Hello! New to SmartSheet. Was wondering if there is any way to do a "Check-in" with multiple forms. For example, 7 unique forms with separate location/date (hidden values?) with one entry of an employee number. Then the sheet would have one row of data with the first column being the employee number and the second column…
-
The IF function
I want to be able to type in the field if the Value is False. I can copy the formula to all the field in the column and overtype the formula. but if I convert to a column formula then I cant do this. Any ideas?
-
Trying to reference two sheets but having trouble with second reference
Hello, I created active project and archive project sheets. When a project is completed, it is automatically moved to the archive sheet. I set up a timesheet that references both sheets and looks for the project ID to automatically fill in the three fields for project name, project type, and solution type. It works fine…