-
Track Daily Variance Between Forecast to Actuals Across Multiple Cells and Sheets into Master View
Hello, I am desperate for some guidance on the best way to handle my situation. First, I have 2 sheets that I'm attempting to provide an executive view for: * First sheet is a forecast that indicates the number of people we should be training in any product line. The individual product lines are listed in the primary…
-
Help with Adding Additions to IF and ISBlank Formula
Hi, I am hoping someone can help with the below formula additions we would like to make as it would be greatly appreicated! * Today our formula provides a status of In Progress for NIR code and LI code in the SMCC Action column. Once an actual date is entered into the “Actual Date Request Completed” column it will flip the…
-
Moved data from one sheet to another sheet - now its not showing up
I just moved data from one sheet to go onto another sheet and now it’s completely gone and not showing up. I refreshed and went back into the sheet the information was suppose to be moved to but it’s nowhere to be found. I am trying not to panic.
-
Link Separate Smartsheets into a 'super sheet'
I have a manager who is literally managing over 150 projects. He has a SmartSheet with a list of them all and a few simple notes. I'll call it his "Project Summary Smartsheet." He neither needs nor wants the entire detailed breakdown of each individual project; he just wants the overall project view. Is there a way to link…
-
Permissions to edit cells
Hello all. I have several work flow sheets, in which collaborators have to change the status of the tasks, but not all collaborators could change any status. The question is possible edit permissions on cells to avoid that any user could change it? Thanks
-
Moving Smartsheet Items to New account
Good day, I would like to know using the scenario below as reference: If used my friends account to work on Smartsheet, and now I want to purchase my own Smartsheet account. Would I be able to transfer the Smartsheet data that i worked on, on my friends account, over to my newly purchased Smartsheet account. Ps, Its not a…
-
Limiting Auto Number to Specific Range
Hi, I'd like to add an auto number column, but I would like to set the specific range in numbers. For example, I need the auto numbers to be between 0 and 250 without duplicating. Is there a way to set those limits? Thanks. Jay Duque
-
Match Statement with Multiple Sheets
Hi, Due to the limited restraints on the # of rows (5,000) in Smartsheet - I need to create a formula that references multiple sheets for a match statement. See below: =IFERROR(IF(MATCH(([Employee ID]1 + [Current Position]1 + [Training Name]1), {Completions(1) Range 1}, 0) > 0, "YES", "NO"), "NO") I have another sheet…
-
Free users can no longer use "send..." on a row
Hi, has something changed for free users with the send option at a row level? we have a number of admin users but also free users than will fill out details in a row and then click the row dropdown and select the "send..." to send a mail with the details filled out for that rown. Now when our basic (free) users select this…
-
Issue adding email address
Hi, Our organisation was merged into a new organisation, and I'm now trying to add my new email address to be the primary email address now that they finally closed the old email address. I tried to add my new email address, but it comes back with en error message saying that my new email account is already associated with…
