-
How to change account Credentials
Good day Smartsheet Support How do I Riana this account user change my account credentials to another username and password. I am not using this account, but my college is using this account with my credentials. Can you please assist me in how to go forward by changing my account credentials to another users' credentials.…
-
Form Design Displaying non-Character text
Have come back into my form design today and am unable to read the text displayed. This error is not persistent in the form entry as seen by the end user or in the sheet view, but is impacting the design side. Has anyone come across this and has a workaround? The only thing I could think to try was modifying one field, and…
-
Cell Linking Iterations
Hello there! I was wondering if there may be a way to format iterations to cell linking. I have an Intake Sheet, which then goes to multiple sheets. Being the "master" sheet, most of our Leadership will only be looking at this sheet. Is there a way where I can link an approval date, and then run an iteration or function to…
-
Removing Parent Rows in a report
Hello, I am trying to create a report that doesn't incorporate the parent rows from multiple sheets. I have read a lot of suggestions, most involve creating a helper column based on one of these two formulas =IF(COUNT(CHILDREN([Task Name]@row)) > 0; = COUNT(ANCESTORS()) + 1) however, Smartsheet won't let me make the first…
-
Need assistance with a Metric
Hi, I am trying to get the % of task within a milestone that are complete. I trying to use: "=SUMIFS({Status}, "Complete", {Milestone}, "30 Days post Merger Date Milestone") / [Total of tasks]@row" but I keep getting an error. I think it has to do with the "/[Totalof tasks]@" row but I can't figure it out. Thanks!
-
Why many free users get the message of Account blocked?
Hello, I'm a Workspace admin in our company and several colleagues reached out to me saying they can't access the sheets anymore and share a screenshot saying: "Your account has been blocked by your account Administrator. Please reach out to them for assistance." Do you know how can this issue be solved?
-
Automatic saving
The save duration is too long: 1 minute when we are not processing, when we are processing we have to keep pressing save. Is it possible to save automatically when entered? Or shorten the duration to 5-10 secs. Even Gsheet can save automatically :/
-
Automation workflow issue
I have an active defect sheet. I have a second sheet where closed IT tickets get archived. The first automation is Archive when Closed. Trigger: When rows are changed AND when 'Ticket Stage' changes to 'CLOSED' Actions: Move a row. However, I am trying to add a second automation. Showstopper closed. I did the following…
-
Change calendar (column type: date) to years (not months)
Hi all, Just a quick question - when using the column type 'date' in a sheet, is it possible to make the calendar which comes up for selecting the date in question a 'year' calendar rather than a 'month' calendar? Many people using the sheet/form will be inputting dates from about 50 years ago, so a calendar by month…
-
Where to start? (Project Management)
Happy New Year! I'm attempting to learn how to use Smartsheet to manage our Training Department's many multi-faceted projects. As I sort through all Smartsheet offers, I'm becoming increasingly frustrated because my budget doesn't allow for me to take multiple courses in order to earn the badges I would need to qualify to…